I have a text field called 'Item' in a Estimate Data table which I use to prepare and generate Quotes. This field is used to input data either directly or by copying and pasting from another document. It has a calculated value to make sure all text is formatted and sized the same - see below:
My problem is that this same field that I use to prepare the Quote on the Quote Layout is also used in my layout used to print the Quote - hope that makes sense. So I've used an 'if' statement to differentiate how the fonts should look on the layouts.
But this calculation is not working. NOTE: The 'Do not replace existing value of field (if any)' is unchecked.
Is there away to display fonts from the same field differently in different layouts?