combo box displays numeric ID, not text

  • Thread starter Thread starter Techknownothing
  • Start date Start date
T

Techknownothing

I have a combo box that is populated by the fields from a table (States
in the Northeast).
The form displays the ID instead of the corresponding text (the actual
name of the State).
How do I make the form display the corresponding text instead of the ID?
 
I changed the width of the first field in the source table to zero and
the form still gives me the ID.

Techknownothing
 
Please list the fields in the sequence they appear in the query

Please indicated from the Format tab what the column count is:

Please list the field lengths as they are shown in the format Tab under
column Widths:
 

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

Back
Top