Following lines get printed in a report in the mentioned format. I want to change the font color of the "^" symbol to something different. how do i do it through formula? the number of lines and ^ symbols gets generated dynamically so it can be multiple lines for different cases. 

 

Line1

^

Line2

^

Line3

^

Line4

 

thanks

Pinakee

 

If would go something like this...

 

If Char(32) then crRed else crblack;

 

I have used this quite a bit to set the color of checkmarks and other special characters in the WingDings fonts. If you have Brian's book you will find it discussed there as well.

 

I always get the syntax wrong  on the ascii character code but feel free to look in the help file. Just know that this is the color the character will be, so if you want an 'a' to be red in that text object or field all 'a's will red. You would need alot more logic to control what is happening if that is what you want.

 

Hope this helps.

 

Regards,

John W.