Combo boxes and lists boxes not showing data

[Annette]

As of yesterday, a few databases stopped showing data in list boxes
and combo boxes. The row source to these fields have not changed and
they show the correct data in the query. The column widths are correct
and the fore and back colors of the fields are not the same. This just
started happening yesterday and nothing has really changed.

Also, if I click somewhere in the combo box on a blank entry (because
I can see anything), after I click the information will display, but I
can't see it when I first click the drop down arrow in the field.

HELP!!!

 

[Annette]

As of yesterday, a few databases stopped showing data in list boxes
and combo boxes. The row source to these fields have not changed and
they show the correct data in the query. The column widths are correct
and the fore and back colors of the fields are not the same. This just
started happening yesterday and nothing has really changed.

Also, if I click somewhere in the combo box on a blank entry (because
I can see anything), after I click the information will display, but I
can't see it when I first click the drop down arrow in the field.

HELP!!!

Ah, I figured it out! Microsoft has a kb articlie on this (http://
support.microsoft.com/kb/945280). It notes this happens after you
install Office 2003 SP3. Any field that has a display format, in my
case ">", this will happen. Removing the formatting will solve the
problem or else there is an Access 2003 post-sp3 hotfix package dated
December 18, 2007 that will correct this.