Decimal

[kitty77]

I have the following in an unbound field, how can I force this to be 2 decimal places?

="+/- " & [Number1]

 

[theDBguy]

Go to the Format property and try Fixed with 2 decimal places.

 

[kitty77]

Doesn't work? Because of the text at the beginning?

 

[theDBguy]

Doesn't work? Because of the text at the beginning?

Oh, you could try the following instead (untested)

="+/-" & Format([Number], "0.00")

 

[kitty77]

That worked. Thanks!!

 

[theDBguy]

That worked. Thanks!!

Good luck!

 

[Josef P.]

Just for info:
"+/-" could also be set via the format property of the textbox. Then the value remains a number.

 

[Pat Hartman]

Just FYI, formatting doesn't limit the decimal places to 2. It just obfuscates the actual value. If you actually want to store only a fixed two decimal places, you need to round the result in the calculation.