Combo Box Display issues

[Sean Henry]

All of a sudden a clients comobo boxes dont display the first colum (happens
to be the ID). We dont know of anything fundementally changing over the
weekend.

Other ocmbo boxes work! So the only thing we can get to is a more complex
combo box seems not to display the first column, and simple ones are fine.

Does anyone have any clue about this? I doubt it is actually related to
Access, but I dont know how to start troubleshooting.

 

[Allen Browne]

Sean, is this Access 2003?

If so, your machine may have downloaded Service Pack 3 for Office 2003.
There's a bug in the SP where the combo whose RowSource is a table that has
something in its Format property.

There's a demo of this and another bug in this sample db:
http://allenbrowne.com/temp/A2003sp3bug.zip

 

[Sean Henry]

Thank you so much. Im checking with the client to see,a nd if so I will post
it back here!

 

[CurtainMary]

Wow, thanks Allen, I was hoping that a MVP would get onto this. Glad that
professionals like you show some interest in us amateurs.
CurtainMary