Recent content by 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...

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.

I have a table in which one field badly needs separating into two. Currently, it is laid out as a mixed case text string followed by an upper case text string, e.g. O little town of Bethlehem FOREST GREEN. I need to move the upper case string (FOREST GREEN) to a new field (and then trim the...