combo list not showing data

[Jay]

I have an inventory database and after changing computers I have two computer
which will not show the contents of the combo boxes. These are linked to a
Query from a different table. The data is still there as you can use your
mouse wheel and scroll through the list but the data does not show when you
drop your list. One computer is an HP the other is an IBM. The data used to
show before we changed the computer. The data shows on my computer as well as
another hooked up to the network. No other changes have been made to the
database. I have tried changeing font colors, fore colors and back colors to
no avail. I have one bos which will show the data but it is linke to the
table for the form. HELP, any suggestions would be great. I have already
compared the working list to the non-working list and the attributes are the
same except where the data comes from.

 

[Tom Wickerath]

Hi Jay,

On the computers that are having these display problems, please provide more
details including:

1.) Operating System and service pack level
Click on Start | Run and enter the command: winver

2.) Version of Access, including service pack level

If the PCs are running Access 2003 with service pack 3, they may need a
hotfix applied:

Bugs introduced by SP3 for Office 2003
http://allenbrowne.com/bug-Access2003SP3.html

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

If the PCs are running Access 2007, you may have this issue:

Combo becomes transparent
A combo may display as transparent when focus leaves it. Workaround: set
the AlternateBackColor property of the the (Detail?) Section to something
other than "No Color", e.g. #80000027.

Reference: http://allenbrowne.com/Access2007.html#Bugs
See the section subtitled: "What's broken (new bugs)"


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Douglas J. Steele]

Let me guess (since you don't say). Is this Access 2003? Did you recently
install SP3?

If so, get the post Service Pack 3 hotfix at
http://support.microsoft.com/kb/945674

 

[Jay]

Thank you, Thank you.
The 2 computers the lists were not working on are SP3 but mine is SP2, the
link you directed me to was the fix I needed.

 

[Tom Wickerath]

Wonderful!
Thanks for reporting back.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________