removing auto formatting on numbers

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
The best you can do is to set the Format property of your field to 000
(assuming all values will have 3 numerals).
 
I suppose you could set the type to Text.
Then you have to convert it to a number everywhere you used is.
 
Back
Top