Hex number field

[AlanKempster]

Hi,

I'm sure this is a dumb question, but I need to create a table with a hex number field. There's no option that I can see (Access 2003) to designate hex as a number type. Should I set it up as a text field?

Thanks.

 

[Dennisk]

Hex fields have to be text to store 0-9 and A-F

 

[RuralGuy]

How large a Hex number will you be dealing with?

 

[Zigzag]

Hi,

Can you not store it as decimal in a table and convert it to Hex as and when you need to work with it?

Garry

 

[neileg]

I agree with Zigzag. Unless you store it as decimal, you're going to have to develop your own maths functions. Build a conversion function for display and let Access do the decimal maths.

 

[Dennisk]

You don't need to convert anything as Access accepts Hex values. Precede the Vlaue with &H

for example in the debug window enter ? &HFF
and the print statement will return 255

 

[AlanKempster]

Thanks for all your replies. The hex number will always have 8 digits/characters. I don't have any need for its decimal equivalent, since it's an individual key code encoded into each piece of hardware my company sells. All I want to do is record which hex key code has been encoded into each unit (identified by its serial number). I think treating it as a text field is probably best in this scenario.

All I need now is an auto-incrementing text field!