Field Formatting - False Zeros

L

Lobster Girl

Access 2003

Is it possible to format an existing field to incorporate false zeros?
Example: The current field is a number data type with general formatting to
show trap number 1 up through 103. However, for future analysis it would be
great to have trap number show up as 001, rather than just 1.

Any suggestions?
 
L

Lance

A value of 001 can only appear in a text field, you may be to able to fiddle
with display formatting to make it appear as 001 in a number field.. but the
actual value will still be 1.

You would need to convert your field type to text and then fix each entry to
meet the 00# criteria. Might be easiest to do this by making a query based
on the exist table and using it to create a replacement table with the text
field.

Of course switching field types is bound to cause all kinds of problems with
existing elements of your database.
 
Top