Combo Box List not visible

  • Thread starter lizo.consulting
  • 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. ;-)
 
J

Jeff Boyce

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
 
A

Arvin Meyer [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.
 
L

lizo.consulting

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

I am on 2003 sp3. Ugh. Should I roll back to sp2?
 
T

Thomas

Hello sorry maybe I missed something here but

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top