Formatting Number in Query View

T

Tiz

I'm trying to format calculated fields Charges/Units and Payments/Units to
display 2 decimal places. The Charges/Units allows me to select the
DecimalPlaces in the Properties Box. The Payments/Units field does not show
me the option to select DecimalPlaces. It goes from Format to InputMask.
How do I specify 2 decimal places in that case?
 

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

Creating a Chart on form from selected data in query. 0
Printing Outline view - formatting lost 0
Custom Number sequences 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Mail Merge - displaying a conditional number of decimals 5
Add a (sequential not autonumber) number in append query 5
Using the format function for a percent with four decimal places 5
Format change in merge data - Bold formatting after a comma 0

Top