Decimal point issue, Unbound Textbox In Form with math equation

[MFS]

I have an unbound textbox in my form where I have entered a math equation, the equation works very well however the numbers could possibly show up to infinite.
ie 23.187678498979843569784938269437256764328



I would only like the textbox to show 23.18
I've tried setting the "Format" in properties to General Number and "Decimal Places" to 2.

I hope someone can help me get this formatted correctly.

Speck

[ItsMe]

You might be able to get what you want using Format = General Number and Decimal Places = 2. However, understand that the format is only something that is displayed to the user. The underlying data that is actually being stored will likely be very different. This might cause issue when running aggregate calcs on data stored in tables.

What I will typically do is use a specific data type in VBA code and do data validation before assigning the value to the field within the table. Using variables with specific data types and doing validation will likely bypass any need for using the Format property and will also provide more reliable results when doing math on the data stored in your tables.

This reference may offer some help
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

[NTC]

Set your property to 'Fixed' and decimals property to '2'.

that's step 1; but in your example it is going to display 23.19 not 23.18 due to normal rounding.

If you require round down - then bing/google on that that topic