combo list not showing data

  • Thread starter Thread starter Jay
  • Start date Start date
J

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.
 
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/
__________________________________________
 
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.
 
Back
Top