decimal places

N

Nick T

Hi,
I have 3 text boxes on a form which display numbers. How do i get them to
only display the numbers to 2 decimal places? They are currently eg.
2.34566572738 etc. I have tried changing the 'decimal places' in the text
boxes' properties list, but this doesnt work.

Any suggestions

Thanks
 
A

Allen Browne

Set the Format property of the text box to Fixed, as well as the Decimal
Places to 2.

Note that this only suppresses the display of further values beyond 2
places: it does not round the value to 2 places.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

decimal laces 13
Access stripping decimal places in query 1
format a number field to only show 2 decimal places if there are a 6
Decimal Places 1
Decimal places in report 2
How do you turn off automatic rounding in a query IIf statement? 2
Conditional Decimal Places 7
decimal places 2

Top