Column Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my form I have a text box that pulls data from another table. There are 2
fields in the other table and when you click on the text box it shows both
fields. The column count is set to 2. The 1st field is an automatic number
and the 2nd field is the description. I only want to show the description
(2nd field) but if I change it to 1 it only shows me the automatic number.
Is there anyway of doing this?

thanks..
 
Hi, Franca. Sounds like this is a combo box rather than a textbox. If so,
keep the Column Count equal to 2, set the Bound Column to 1 if it's not now,
and change the Column Width property to 0";x", where x is how wide you'd like
the 2nd column to appear, in inches. This way, what you store in the table
will be the key field, but it will display the second.

HTH
Sprinks
 
Back
Top