Combo box

[Annette]

This is so weird.

I have a form with a combo box. The combo box on the form is based on
a query. The query has two fields in it. The combo box is to show both
fields with the first field being bound.

When I run the form I see NOTHING in the combo box selection. I use
the drop down arrow to the right of the combo box and scroll down
(seeing nothing) and select some blank area and then I see the
desciption.

Why am I not seeing anything?

I tried this with a list box as well. Is there something set up in the
table wrong? I just can't see anything until I click somewhere in the
combo box then I see the text of the entry clicked.

HELP!

 

[Annette]

This is so weird.

I have a form with a combo box. The combo box on the form is based on
a query. The query has two fields in it. The combo box is to show both
fields with the first field being bound.

When I run the form I see NOTHING in the combo box selection. I use
the drop down arrow to the right of the combo box and scroll down
(seeing nothing) and select some blank area and then I see the
desciption.

Why am I not seeing anything?

I tried this with a list box as well. Is there something set up in the
table wrong? I just can't see anything until I click somewhere in the
combo box then I see the text of the entry clicked.

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.