Re: Combo box in a Form

You should be able to fix it in A2003. At worst, you could uninstall Office 2003, and take the service patches to SP2 only. However, all my databases work with SP3, so it should be possible.

If you had to choose between A2007 and XP, my recommendation would be XP at this time. Until MS releases SP1 for A2007, it's too unstable. Details:
http://allenbrowne.com/Access2007.html#Bugs

--
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:eizkBYgMIHA.5172@xxxxxxxxxxxxxxxxxxxxxxx
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.

"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: Lost welcome screen XP
    ... I'm running SP3. ... I was hoping that SP3 would fix it. ... have already tried the control panel "change how users log on" choices, ... Kelly's corner fix, and the DougKnox tool. ...
    (microsoft.public.windowsxp.basics)
  • Re: Lost welcome screen XP
    ... I tried that but unfortunately I have SP3 installed, ... Also noticed my windows insttaller doesn't work. ... run because it says windows installer is not working or something. ... I was hoping that SP3 would fix ...
    (microsoft.public.windowsxp.basics)
  • RE: Data not displaying in combo list box
    ... HAS ANYONE OUT THERE HEARD ANYTHING FROM MS YET ABOUT HOW TO FIX THIS? ... You can see my thread "Microsoft Access Combobox with SP3" in this same forum. ... I also had the same problem and received this response from Ken Snell. ...
    (microsoft.public.access.forms)
  • Re: Access crushes after SP3 installed
    ... I'm now getting this error after applying SP3 yesterday. ... is the only resolution to uninstall Office 2003 and ... Every table in my database has more than 10 fields. ... I am personally do not using any type of formatting for a table. ...
    (microsoft.public.access.formscoding)
  • Re: Errors in Access after installation of Office SP3
    ... I've noticed that Ken Snell has provided a workaround for this issue on your posting to the MS Office Access discussion group. ... I have jsut installed Office 2003 SP3 and have noticed that my application ... to uninstall Office 2003 and reinstall it and all the KBs except SP3! ... MS Office Community discussion/newsgroups via Web Browser ...
    (microsoft.public.officeupdate)