If (Budget Type="Working"; TextStyleAdd(ProdCPE;Italic); ProdCPE)
However, in order for this calculation to work, I have to remove the dollar formatting from the field so my numbers are just appearing as entered: 123456 rather than: $123,456
Any suggestions on how to maintain the dollar formatting along with the change in style to italics?
Thanks so much!
Have you tried inserting the $ sign in your calculation?
If (Budget Type="Working"; "$" & TextStyleAdd(ProdCPE;Italic); ProdCPE)
or if you want the $ sign to be in italics
If (Budget Type="Working"; TextStyleAdd( ("$" & ProdCPE ) ;Italic); ProdCPE)
helpful - thanks so much - but it does not fully solve the problem. it still does not format the number in the aesthetic I'd like it to. It does not not add the comma to the number.
i would like the number to look like this "$123,456" not "$123456"
Back before we had the options described in this post, we sometimes used two fields stacked on top of each other, each with different formats specified for the field.
Field 1 could be If ( BudgetType = "Working" ; Production Cost ; "" ) set to return a number type. Format this field as currency and also with italics.
Field 2 could be If ( BudgetType ≠ "Working" ; Production Cost ; "" ). Format this field as currency but don't format with italics as its text style.
You can't edit the Production Cost field on this layout without scripting a custom dialog or some such to popup when the field is clicked, but it will work for printing/previewing reports.
Edit note: Rewrote last sentence to improve clarity.
thanks. that did it.