I have a field with Canadian Postal codes [FSA] 3 characters long, sometimes I have to add a '- 012...' or 'OLD' indicating the year it was updated. What I need is, if more than 3 characters in the field have the font in red.
Good afternoon JacquesSabourin,
I hope your day is going well. Try using a calculation similar to this:
Length ( YourField ) >3
Good luck. Have a great evening!
You may use "Auto Enter Calculation" ( "Do not replace..." option must be unchecked) with a calculation like:
[ threechars = left ( zipcode ; 3 ) ;
otherchars = middle ( zipcode ; 4 ; 9999 ) ];
threechars ≠ zipcode ;
TextColor ( threechars ; RGB ( 255 ; 0 ; 0 ) ) & otherchars ;
Retrieving data ...