Combo Box Not Displaying Correctly

[Kyle]

I have a number of combo boxes set up on a form I have created. They were
working fine, but now they are not displaying correctly.

They each have two columns, but the bound column is no longer visible. For
example...

Column 1 Column 2
Supplier Code Supplier Name

I have enabled column headers and they both are visible, but in this case
the values in the supplier code column are not displayed. I suspect that I
made a change to the form design that has caused this, but I cannot determine
what it was that I did.

I'm stumped! Suggestions?

Thanks, Kyle

 

[Douglas J. Steele]

When you say the values are not displayed, do you mean nothing appears, or
that you get an empty llist, complete with scroll bar and all? If the
latter, are you using Access 2003, and did you just recently apply SP3? If
so, apply the hotfix from http://support.microsoft.com/kb/945674

If that's not the case, please provide more details.

 

[MikeJohnB]

One thought, firstly, what version of Access?

If its 2003, have you installed sp3 recently? If so, there is a problem with
table formats that require a hot fix to solve.

Here is a link to Allen Browne's solution

http://allenbrowne.com/bug-Access2003SP3.html

I overcame my problem by deleting the format of each field in the table that
the lookup was based on and formating in the control

If its any other version of access, please ignor and sorry I don't have any
other ideas.

I hope this helps????

Kindest Regards

Mike B

 

[MikeJohnB]

One other thing, have you tried running the Query of the combo box the see if
it gets populated.

Combo Box properties
Row Source
Click the button with three dots ...
Run the query that pops up. What do you get returned in the query?

Kindest regards
Mike B