data display

[golan]

hello, i have a combobox in form. the data display is text.
the combobox based on table(1).
the combobox be fed another table(2).
the datadisplay in table2(2) is number (the id number of the text).
example:combobox:golan,feild table(2):1.
i want in table2 text not number.
thanks,

 

[Bill Mosca]

Set the column widths in the combo box so that the ID column has a width of
0 and the text column is sufficiently wide enough to show it.

If the fields in the table are ordered with the ID in the first field and
the text in the second field, the Column Widths property would look
something like:

Column Widths: 0";1.5"

 

[KARL DEWEY]

This might not be your solution based on what kind of field you are bound to.
Either change the record source to only the text field or set the text field
as bound column.

Lots of times the bound field is numerical to store the ID. Then in a query
join on the ID and display the text.