How do I display trailing decimal zeros, but only when entered?

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

Guest

If I type in 35.60 it's important that the field display the trailing zero
and not automatically truncate it to 35.6. However, I don't want it to
automatically enter two decimals either. So that if I type only 35.6 I want
it to display that and not 35.60. Is it possible for a number field to simply
display "exactly what I type" or do I have to change the field to text
characters? This is important in not changing the precision of the numbers I
need to enter. Any suggestions would be appreciated
 
Scientifically said:
If I type in 35.60 it's important that the field display the trailing
zero and not automatically truncate it to 35.6. However, I don't want
it to automatically enter two decimals either. So that if I type only
35.6 I want it to display that and not 35.60. Is it possible for a
number field to simply display "exactly what I type" or do I have to
change the field to text characters? This is important in not
changing the precision of the numbers I need to enter. Any
suggestions would be appreciated
Click to expand...

I can only think of two ways. Enter it as text not numbers, and then it
will not be available for computations and sorts will come out strange or
plan on some interesting VBA work.
 
You can not make it display exactly what you type but you can pre-set the
FORMAT for your display. In design view for your form or report set the
Format property for the display you want.
 
Back
Top