Re: Combo box in a Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Allen,

Yes, I am using Access 2003 with SP3. I believe the trouble started when I
upgraded from Access XP. I could upgrade to Access 2007: would that fix the
problem? Or, should I revert to Access XP?

I had > in the Format property of the Rowsource field of the table and I
deleted this >. However, it did not help.

Thanks,
Steven


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message
news:enwhT8ZMIHA.3852@xxxxxxxxxxxxxxxxxxxxxxx
Steven, any chance this is Access 2003?
And did you recently install Service Pack 3 for Office 2003?
(Help | About will give you version and SP info.)

There are known problems with this service pack, including blank columns
in the combo if you have anything in the Format property of the field in
your table. We have half a dozen SP3 bugs listed at the top of this page:
http://allenbrowne.com/tips.html

If that's not the case, post back with info about your version, and the
properties of the combo.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steven Zarda" <zarda@xxxxxxxxxxxxxxx> wrote in message
news:%23upSFwYMIHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
I have a combo box in a form. It used to work fine for years but started
misbehaving recently. When I scroll through entries in the form, the
contents of the combo box are ok but I can not use the form to create a
new entry. When I open the combo box to select an entry, a list opens in
the box but it is empty i.e. it contains blanks.
Any suggestions?
Steven



.

Relevant Pages

  • Re: BSODs
    ... SP3, for example, has been installed on ... months to upgrade to SP2? ... As for unsolicited advice. ... But go ahead and encourage people to install things that have a good ...
    (microsoft.public.windowsxp.help_and_support)
  • Windows XP Service Pack 3
    ... this might be useful info for anyone looking to upgrade their Windows XP setup with Service Pack 3. ... Last week I used the Microsoft Update website to try and upgrade to SP3 for my XP Pro setup. ... The result was a faultless install and cleanup taking about 20 minutes. ...
    (uk.local.surrey)
  • Re: Upgrading to SP3
    ... The SP3 installation ... It is highly recommended you image your hard drive before the upgrade. ... If you have done your homework, Windows Update should work for you. ...
    (microsoft.public.windowsxp.basics)
  • Re: Whizzing HD: nothing to see in Process Explorer?
    ... Just to say thanks and I've now apparently gone through the SP3 process ... Service Pack upgrade. ... The installation will fail if there are devices connected to ... (e.g., USB external hard drives, printers, etc.) ...
    (microsoft.public.windowsxp.general)
  • Re: Dell Dimension E521+Windows XP MCE 2005+SP3 Experience
    ... Before you do a SP3 upgrade, I can't stress enough, that you should ... If you have the following Dell PC with an AMD Processor, ... backup of the keys listed below, ... The upgrade worked, and I left the keys there in the registry. ...
    (alt.sys.pc-clone.dell)