TEXTBOX help

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

Can anyone tell me if there is a way to take a textbox
that is getting data from a table and in a form can I
have it display the data name instead of the value?
I know this works with a drop down or listbox but would
like to do it with a text box if I can

Thank you
Paul
 
I can't think of how to do it the way you've described it. If you give a little more
detail about what you're trying to accomplish there may be a way to do something that will
look and act similarly.
 
What i mean is i have a field with this
Expr1: [CompanyName] & " " & [ContactFirstName] & " " &
[ContactLastName]
as the row source and if it is a drop down list or combo
box it shows the info i am looking for but i do not want
to change it so i would rather have it as a text box, but
when i do it only shows the ID number ie.. i want it to
say "ABC company John Smith" but it will show customer id
" 1 " if it is a text box ONLY

thank you
 
The value of a combo box is the value in its Bound column for the selected row. You need
to change the textbox's Control Source to Expr1 to use the calculated field.
 
Back
Top