display 2 decimal digits

[Fredrated]

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

 

[Douglas J. Steele]

Try setting the field's format to #.00

 

[Tom Lake]

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

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

Tom Lake