Combo Box Text not appearing

[Paul]

I have a combo box in a form used to select different people from our
training division. Looking at the properties it seems it should be fine.
However, the list that drops down in the combo box is blank, yet when I click
on the blank spaces a sailors name actually enters in the combo box. The
information is being stored properly, but it is a pain to have to sift
through invisible names in order to find who it is im trying to pull
information up about. If someone is familiar with this problem and could
direct me how to get the list to actually show text rather than being blank
with "invisible text" that would be greatly appreciated.

Thanks
Paul

 

[Jeff Boyce]

Paul

Which column is "bound"? What is the column width(s) of the column(s)?
What is the SQL of the query that "feeds" the combobox?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Paul]

bound column is 1; column widths are: 0";1.5938";0.4167" ; SQL is: 'SELECT
Personnel.PersonnelID, Personnel.Name, Personnel.Rate FROM Personnel;'

 

[BruceM]

What is the column count?

bound column is 1; column widths are: 0";1.5938";0.4167" ; SQL is: 'SELECT
Personnel.PersonnelID, Personnel.Name, Personnel.Rate FROM Personnel;'

 

[fredg]

I have a combo box in a form used to select different people from our
training division. Looking at the properties it seems it should be fine.
However, the list that drops down in the combo box is blank, yet when I click
on the blank spaces a sailors name actually enters in the combo box. The
information is being stored properly, but it is a pain to have to sift
through invisible names in order to find who it is im trying to pull
information up about. If someone is familiar with this problem and could
direct me how to get the list to actually show text rather than being blank
with "invisible text" that would be greatly appreciated.

Thanks
Paul

Have you recently installed Access 2003 Service Pack 3?
Could be the Service Pack 3 bug.
See this link for details on the hotfix.

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

 

[Douglas J. Steele]

Are you using Access 2003? Did you recently install SP3?

If so, try applying the hot fix at http://support.microsoft.com/kb/945674

 

[Paul]

the column count is: 3

What is the column count?

 

[BruceM]

So much for that idea. It was worth a shot.

the column count is: 3

 

[Paul]

It looks like that could be it..however I have to wait untilt he IT
Adminstrator comes down because I work on DoD computers and dont have the
proper clearance. Appreciate the help fellas and will let you know if it
works as soon as the IT guy comes in.

Thanks
Paul