Combo Box Wizard

[Lamar]

I use the Combo Box Wizard to create a cbo to find a record on my form based
on a value I select. My values are Last Name and First Name.

However, in the drop-down menu I can not see the values but they are there.
So I can select something (I can not see) in the cbo and then the record
appears on the form. I have checked font and background and that does not
seem to be problem.

Any help is appreciated.

Thanks Lamar

 

[KARL DEWEY]

Open your form in design view, click on the combo, double click the combo,
scroll down and select Properties. In the Properties window select the All
tab.

Post the information from the following --
Control Source
Column Count
Column Widths
Row Source
Row Type
Bound Column

Someone can analyze the information an advise you how to change it.

 

[Linq Adams via AccessMonster.com]

Unfortunately, you've apparently running v2003 and have updated to the SP3
service pack and it's buggier than the Great Dismal Swamp! One of the most
common bugs reported involves comboboxes with disappearing data! Sound
familiar? The "disappearing" field(s) in the underlying table have some kind
of formatting in place.

This is often the simple > used to force UpperCase. Remove any formatting
from the fields and things should work short term, but the definitive
solution is to install the hotfix for SP3. Here’s the link for the hotfix:

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