removing auto formatting on numbers

M

Mark

I would like to remove the auto formatting feature so
that I can enter the number 074 into a record. This is
always chopped down to 74. How do I remove this feature,
as in this case the number 074 is important and the
number 74 is useless. This is a case where the record is
called GPS Minutes, where the 074 represents the minutes,
and 74 does not. As this number will be altered by an
equation later on, I cannot simply classify the field as
text. Thank you for your help.
 
L

Lynn Trapp

The best you can do is to set the Format property of your field to 000
(assuming all values will have 3 numerals).
 
D

Doug Chinnock

I suppose you could set the type to Text.
Then you have to convert it to a number everywhere you used is.
 

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

Top