data display

  • Thread starter Thread starter golan
  • Start date Start date
G

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,
 
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"
 
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.
 
Back
Top