The formatting that you impose with the Inspector is a presentation layer effect only.
you already figured that out.
Here is a custom function that can imposes number formatting at the data layer or within scripts
If you put the following on your layout:
The total amount of <<number>> should be paid ASAP.
then click on it and set the number formatting as you like it, then you're done.
Mergefieldmagic.fmp12.zip 65.7 K
Nice, this keeps formatting in the presentation layer. I forgot you could format merges.
Thank you gentlemen.
Both replies were insightful.
The custom function was just what I needed and it's already happily humming along in my solution.
The formatting in the presentation layer is certainly worth remembering.