Putting column as 0cm ; 7cm to show one column while recording numbers

Leaden

Registered User.
Local time
Today, 01:02
Joined
Feb 7, 2016
Messages
21
Hello, I have been looking for ways to make a dropdown menu in the form to show a option while recording number into the table, for example, to show (Yes, No, Don't Know, Missing data), and to record 1,2,3,4 in table respectively.

Some people said do the lookup field and do 2 columns with 1 bound column set the column width as 0cm;7cm, and it has worked perfectly, except, now when I need to extract data to excel and analyze it, it just shows me the yes, no, don't now, missing data, instead of 1234.

What can I do to solve this?
 
Don't use Lookup Fields. Use a ComboBox on the form with 0cm;7cm as width. The table will then show the value you want.
 
ughhh is that only way?
I have already made so many lookup fields... dam it
 

Users who are viewing this thread

Back
Top Bottom