Field Formatting - False Zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding in leading zeros and a space to a text field in a table 4
Adding zero to text field types 5
Droping Leading Zeros In Table 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Changing Primary Key numbering format 1
Leading Zeros and Number Datatype? 4
Round up number 2
sequentially numbered text field - not autonumber 2

Back
Top