Text Box

[sajidraza]

Hi
I have create lookup field in table and put data in it. after that i have create form and take text box against the lookup field and bind it with the same field in text box property. but the data not show in text box only digits are shown.
can any one help me in this regards.

Thanks in advance

 

[arnelgp]

its a lookup field so the first field must be an autonumber or PK field.
you will then enable to show the content of the text part when you change it as combobox (right Click->Change To...)on its format property (design view), change to Column Number to 2 and Column Width to 0";1".

 

[theDBguy]

Hi. Welcome to AWF! I would recommend removing the lookup field from the table. See here for some reasons why.

 

[Deleted member 147267]

I agree - remove the lookup field. The numeric value you see is the index number pertaining to each value in the list. Such a field creates a hidden table that stores the values and that index number. When you drop down the field list (in table view) you see the values but Access stores the index number. When you try to make use of this field in forms, reports and queries, Access shows the index number. Usually you can retrieve the value associated with the index number by using the .Value property of the field but you will be better off not using table lookup fields at all. I don't understand the point of them because you're not supposed to be doing data entry directly in tables anyway.