Access 2003
I have a combo box in my personnel table, which draws its data from a trade
code table; the original field in the code table, is numeric, Long Integer,
and formatted with 5 zero's [00000]. The FK in the personnel table is also
Long Integer, and formatted as the original field with zero's.
Data Example:
Original: 5, 9, 15, 99, 128, etc.
Formatted (Padded) with zero's:
00005
00009
00015
00099
00128
etc.
When viewed in the combo box, they appear as formatted, which is perfect,
however, when a code is selected, it reverts to its original format,
removing the padded zeros. Again, the FK field is formatted with the 5 zero's.
As all codes are numeric, a number field was perfect, and I stayed with the
default Long Integer, but at this point, if the formatting won't hold, in
the personnel table, perhaps I should go with an Integer field in the trade
code table, and save a few bytes. However, the real issue is, I need the
formatting.perhaps I should use a text field?
Guidance/suggestions welcome!
Cheers,
Dave