combo box displays numeric ID, not text

  • Thread starter Techknownothing
  • 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?
 
T

Techknownothing

I changed the width of the first field in the source table to zero and
the form still gives me the ID.

Techknownothing
 
R

Ron2006

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