Form Display issue

[Jasper Recto]

I have a form that have several field that are calculated. I change the
format to be Standard with 2 decimal places.

I also removed each field as a tab option.

The form will show the proper decimal places but if I click on the field,
the format changes and shows the more than the 2 decimal places.

How do you stop this from doing that? If you can't stop it, how can I
prevent anybody from click on th fields?

Thanks
Jasper

 

[fredg]

I have a form that have several field that are calculated. I change the
format to be Standard with 2 decimal places.

I also removed each field as a tab option.

The form will show the proper decimal places but if I click on the field,
the format changes and shows the more than the 2 decimal places.

How do you stop this from doing that? If you can't stop it, how can I
prevent anybody from click on th fields?

Thanks
Jasper

Either....

Set the control's
Locked property to Yes
AND it's ..
Enabled property to No.

However, regardless of whether it is displaying 2 decimals or the
full number of decimals, if this control is used in additional
calculations, it will be the full value that will be used, not just
the 2 decimal value.

Or ....
To actually change the value to exactly 2 decimals and be able to use
that value in future calculations, use the Round Function:
=Round([FieldA]/3.6,2)
No need now to lock or un-enable the control.