Combo Box List not visible

  • Thread starter Thread starter lizo.consulting
  • Start date Start date
L

lizo.consulting

I have a combo box in a form that does not display the list of values
pulled from a query (selects customerID & CustomerName from a customer
table -- The customer table is fine and data has not been lost).

Data for the combo box is bound to column 1 (customer id), column
count is 2, column widths are set to 0" & 2".

If I set the column widths to 1" & 2", the customerID data is
displayed, but for some reason the information in the CustomerName
field is not displayed.

If I select a record from the "invisible" list, the customer name is
then be displayed on the form in the combo box, but it is awfully hard
to select from the list because the values aren't displayed.

I have never seen anything like this before... my client is not
experiencing this problem but I am working on a new version of the
database and fear if I give him the update he will "catch" the
problem. ;-)
 
What you are describing sounds like a reported problem that showed up after
SP 3 was deployed for Office 2003. Any chance you are using Access 2003,
SP3?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You don't mention the version, but I remember having a similar corruption
problem in Access 2000. I would try deleting the combo and recreating it.
That's how I solved the issue when I had the same problem.
 
What you are describing sounds like a reported problem that showed up after
SP 3 was deployed for Office 2003. Any chance you are using Access 2003,
SP3?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...

I am on 2003 sp3. Ugh. Should I roll back to sp2?
 
Hello sorry maybe I missed something here but

Column widths should be
0";2"
Not
0" & 2"
 
Back
Top