Hve text combo box values but store integers in field

[accesshelpasker]

Hi,



I am required to store integer values in the fields of the table i am using. However, these will not mean anything to the user inputting the data so I want to use a combo box that will present the user with No, Yes, Unknown but will save 0,-1,99 to the field. Is this possible?

Thanks in advance for your help

accesshelpasker

[pbaldy]

Sure; the typical setup would be a table containing two fields, one for the numeric value and one for the text value. The combo box wizard would guide you through adding a combo to a form based on that.

[accesshelpasker]

Oh now I see you would need to create a look up table and use that.

Thanks a lot Paul for your quick repsonse

Cheers

[pbaldy]

No problem accesshelpasker, happy to help. You don't need to, but that's the typical setup. It's more flexible than hard-coding the options. Welcome to the site by the way.

[accesshelpasker]

Ive now got this working by hard coding the options rather than a look up table. It now appears to display text in what is a numeric field, I've checked its working by filtering the column using 0,-1,99 and it works. Thanks for that.

I now need to know how I am now able to view this data in its raw numeric form so this data can be exported in the required format.

cheers

[pbaldy]

If you're storing the numeric value, you should just be able to export the table. You didn't use a lookup field, did you?

http://access.mvps.org/access/lookupfields.htm

[accesshelpasker]

No, I didn't use a look up table, just typed them in manually using lookup wizard

Cheers

[pbaldy]

I'm aware you didn't do what I suggested. I asked about lookup fields. What happens if you export the table? Can you post the db here?

[accesshelpasker]

I exported the field to excel and it works!!

thanks for your help once again

[pbaldy]

Happy to help.