Format number conditionally on decimal ??

[cowboy]

I have a form with a control source =[Amount]
I am currently using the format 0.##

Problem is if the number is a whole number for instance 2, it will show up with a decimal after it like
2.



Is there a way to make it so if it is a whole number then it wont display a decimal?

[June7]

That looks like an Input Mask. It requires the textbox to display decimal.

If Amount is a field in the form's RecordSource the = sign is not needed.

[cowboy]

Sorry June, I must not have been very clear. These images might help
The first is my textbox properties and the second is the results I am getting.

[June7]

I have never used the Format property with that sort of parameter. It seems more appropriate for InputMask. Did you try removing it?

[cowboy]

You mean something like this?

If I use those settings my results dont seem to follow the decimal places rule for some reason.

[June7]

Need something in the Format property. If you use a Format parameter from the dropdown like Fixed you will get rounded display with the number of decimals specified in DecimalPlaces. If you don't want the decimals to show when the value is a whole number, that would require an expression in the ControlSource and the textbox would not be editable or VBA code to modify the value, both result in a text value. However, it is mathematical convention for all values of an attribute to be displayed with the same precision.