display 2 decimal digits

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

Guest

Is there any way to force single and double datatypes to display 2 decimals
even if there is only one? or none?
for ex:
1 => 1.00
1.3 => 1.30

It would need to display in an updatable query and allow the user to edit
the field.
(The purpose is so numbers line up better for visual inspection)
I can write a function which forces 2 decimals to display, but then the
value would not be editable.

Personally I don't think it is possible, but a user has been bugging me
about it, hence the post.

Thanks in advance for any help, even if to say it is not possible.

Fred
 
Fredrated said:
Is there any way to force single and double datatypes to display 2
decimals
even if there is only one? or none?
for ex:
1 => 1.00
1.3 => 1.30
Click to expand...

You can specify the number of digits to display in a field's properties.

Tom Lake
 
Back
Top