Combo box stopped displaying data

[DaveK]

I have an app in which a combo box is supposed to allow users to select their
name from a list. The list is created by a query. The query works fine when
run standalone, but displays in the box but only the numeric fields part of
the query. The text fields (first name, last name, etc.) are all blank. I
have tried creating new combo boxes with the wizard as well. When using the
wizard, it correctly displays all fields as part of the building process. We
built the app in Access 2000, then switched all users to Access 2003. I even
tried converting the DB to 2003 and creating a new form with new combo boxes.
No joy. Have played with back/fore colors, etc. Anyone know what else to
do? This was working for years and had not had any obvious changes.

 

[Ken Snell [MVP]]

Are you running Office 2003 SP3? Does the combobox control (or the field to
which it's bound) have a value in the Format property? If yes, likely you've
been bitten by a new bug introduced by Office 2003 SP3 package. You'll need
to apply a hotfix:
Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

 

[DaveK]

That was exactly the problem. Thanks very much.