Text not displaying in drop down list in form

[Ducatisto]

Text not displaying in drop down list in form [solved]

This is bizarre to me. The database in question was created with Access 2000 and at work we use XP with Office 2003 and the database in question displays all the text in the drop down boxes as you would expect. I have a lot of data to input so decided to bring it home to work on. Well, I have XP and Office 2003 as well at home so thought all would be well but for some reason a drop down box is not displaying the contents on a form whilst others are. I did the usual by checking font/colour etc but all was the same for all drop down boxes so why this one is not displaying the text on my home PC is beyond me! All I am asking is whether anyone else has experienced this problem and whether there is a simple work around? Thank you.

 

[JANR]

Sounds like the Access SP3 Bug se this link: http://support.microsoft.com/kb/945674

JR

 

[Ducatisto]

Sounds like the Access SP3 Bug se this link: http://support.microsoft.com/kb/945674

JR

Many thanks for the heads up on that, it was indeed the issue and is now resolved. What I did find strange was that other drop down lists displayed correctly!

Thank you.

 

[missinglinq]

This particular bug only affected dropdowns (comboboxes) where the fields had some kind of formatting in place. Apparently some of yours did (the misbehaving ones) and some didn't. The formatting could have been something as simple as the > symbol, used to force uppercase.

 

[Ducatisto]

This particular bug only affected dropdowns (comboboxes) where the fields had some kind of formatting in place. Apparently some of yours did (the misbehaving ones) and some didn't. The formatting could have been something as simple as the > symbol, used to force uppercase.

Yes, that was the denominator in this case so to speak. Forcing caps with the > was the only difference between fields, something learnt here!

 

[missinglinq]

It's always better to know than not to know! Before the hotfix, removing the formatting was the only workaround.