We have address fields on a lot of paperwork and instead of going through each one and amending the formula, is there a way to format the field. When we have a number field I know that you can set the format with the number of decibel places in the format box etc, and I'm hoping its the same for text.
I have tried just simply adding UCase to the format box but it didn't work.
Thanks
Best answer by mohammadnawaz51
Please review above suggestions
+4
Please review above suggestions
+8Hi
As mentioned in the post by
=IIf([BillingContact.Fullname]<>null, Ucaae([BillingContact.FullName])+{br}, ''))
You may be able to wrap the Ucase function around the entire expression, but I'm not sure if {br} is case sensitive or not.
Hope this helps!
Laura
Thank you both. Yes I have tried that and although it does work I just thought there might have been quicker way via format, instead of adding it to the parts within formulas.
If you wrap it around it all, the {br} is put into caps as well and appears in the address as a word BR.
Maybe it will be something that will be developed in the future for formatting fields
😊
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
