syntax for Changeing color of a particular cell

RiteshKS · 2006-02-17

Dear all,

I want to show the color of particular cell in red. but i am unable to find the syntax for setting the color.

i have searched the forum but all i could get the nos. for the color.

Please guide me.

thanks

Luc_VanDyck · 2006-02-17

Write this code in the OnFormat-trigger of your field:

IF Text = '00000' THEN
  CurrForm."Sell-to Customer No.".UPDATEFORECOLOR(255)
ELSE
  CurrForm."Sell-to Customer No.".UPDATEFORECOLOR(0);

Replace IF Text = '00000' THEN with your condition, and replace Sell-to Customer No. with the name of the field.

Savatage · 2006-02-17

you can take it a step further with this post too...

http://www.mibuso.com/forum/viewtopic.php?t=6784

syntax for Changeing color of a particular cell

Comments

Categories