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:
 
Back
Top