Blank rows in combobox 2

[Pampers]

Hi Everyone,
I've got a strange issue. I have a combobox populated through a query. All is well. Except for one machine, where the rows of the combo show as blank rows. The data is there, but it looks like a white font on a white background...??? Users don't have the option to change fonts or set font colors.

Pampers
Keeping it simple can be complicated

 

[PHV]

Any chance that ac2003 SP3 is installed on this machine ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pampers]

Hi PHV,
I will check it out. I keep you posted.
Tnx

Pampers
Keeping it simple can be complicated

 

[Pampers]

Weird thing is that not all combo's show this defect on this particular machine. Some work just fine, some even show the second column in combo, while the first column shows as blank ...

Pampers
Keeping it simple can be complicated

 

[Pampers]

Hi PHV,
I found that - in the table design - if the field format was set ">" (show everything in uppercase) the values showed as blank in the combo derived from that table. This was only on one computer (it is running on 10 or so computers). If this issue was caused by ac2003 sp3 I could not check - didn't had the permission to check this and sysadmin is not around...

Anyway, issue resolved. Tnx for your input.

Pampers
Keeping it simple can be complicated

 

[missinglinq]

This was, indeed, caused by ACC2003 SP3! This is the most reported bug associated with this service pack. Micro$oft has a hotfix for this problem, although, as you've found out, it can be resolved by removing any formatting from the field.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Pampers]

Tnx missinglinq.


Pampers
Keeping it simple can be complicated

 

[missinglinq]

Here's a link to Allen Browne's page with a list of some of the recognized bugs from this service pack as well a a link to the hotfix I mentioned.

http://allenbrowne.com/bug-Access2003SP3.html

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Pampers]

tnx missinglinq,
much appreciated

Pampers
Keeping it simple can be complicated