I have a form with a Qty Shipped field on the form which is actually a Sum of Qty_Shipped for a Packing Slip item. I have run into a situation where I needed to ship decimals (.5 or .25) quantities. 99.9% of the time I ship in numbers with no decimals and I really don't want to format the field to show .00 on every line item. Is there a way I can display the decimals only when they exist, but whole number (without the .00) for the rest of the time? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppressing Decimals if .00 1
- Thread starter GCL2007
- Start date
-
1
- #2
Hi GCL2007
Right click on the sum field and select 'Format Field', then click on 'Customize'.
In the 'Custom Style' dialogue box, click on the x2 button beside 'Decimals', enter the following formula:
Hope this helps.
Cheers
Pete
Right click on the sum field and select 'Format Field', then click on 'Customize'.
In the 'Custom Style' dialogue box, click on the x2 button beside 'Decimals', enter the following formula:
Code:
If CurrentFieldValue = INT(CurrentFieldValue)
Then 0
Else 2Hope this helps.
Cheers
Pete
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question