linked field

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

golan

hello, i have combobox in form , the date is from a query . the data form the
combobox go to field in a table .the data display is number instead of text
("id number" instead of the "name")
golani
 
hello, i have combobox in form , the date is from a query . the data formthe
combobox go to field in a table .the data display is number instead of text
("id number" instead of the "name")
golani
Click to expand...

Sounds like this is a multi-column combobox. You need to change the
column widths to 0;1 (first column width=0, second column width>0).
Then you should be fine.
 
That is the way it is supposed to work. The ID is stored instead of the
text. But, if your combo is displaying the number and not the text then you
need to

1. go into the form in design view
2. click on the combo
3. Find the Number of Columns property and make sure it is set to 2.
4. Find the Column Width property and put 0";1.5" (use the appropriate
measurements for whatever fits).

The 0" tells it to hide that column, so if the first column is your ID
field, it would hide that one and then the 1.5" should display the text if
your combo's rowsource has something like

SELECT ID, Description FROM YourTableName ORDER BY Description;

in it (the names are made up, so your actual field names would be used).
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________
 
Back
Top