Limit field value

S

SID1976

I'm building a form and have a calculation that inputs the result in a text
field. However when the results come back, in some cases the value has many
decimal places. As the figure is supposed to be a monetary value I would like
to reduce the number to 2 decimal places.

Is the a simple format I can apply, or does anyone have anything else I can
use please.
 

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

Get field-value from dropdown-menu value 0
Mail Merge - displaying a conditional number of decimals 5
Drop down list control value in vba 2
ASK Field Formatting 1
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Date Time decimal value help please 1
setting default value field settings 1

Top