Why my column defaults to Number when it is a text

[mp3909]

Hi,



I have this table:



As you can see, the Data type of the field risk_input is showing as a Number.
But when you view the results of the table, it is a text.




How can I get the Data type of this field to not default to number and instead text?

Thanks

[Bob Fitz]

Because you are using lookup in the table , so you see the second column(text) but store the first(Number)
Would strongly advise against using look-ups in the table. See: http://access.mvps.org/access/lookupfields.htm

[mp3909]

So if I wanted to fix this, are you saying I need to change the bound column and column count?

[Bob Fitz]

So if I wanted to fix this, are you saying I need to change the bound column and column count?

If you just change the "Display Control" setting to Text Box, I think that would be sufficient.

[Bob Fitz]

BTW

ID is not a good name for a field. ProdID or ProductID would be better. I assume this will be the Primary Key for the table but even if it weren't, it could soon get confusing when used in queries with other tables if they also have their Primary Key named "ID".

[mp3909]

It won't allow me to change the display setting to text box.

[Bob Fitz]

It won't allow me to change the display setting to text box.

It believe it will. It's one of the three setting available from the dropdown arrow on the far right of the setting which is on the Lookup tab

[June7]

The field will still be number type because that is what is actually getting saved.

Changing to a textbox allows viewing actual value when table is open. Certainly should allow changing.