Coloring a record in Table Box.

I have created a form using the Table Box.

In this table box i have a field QUANTITY. My requirement is that i want to color the whole record line if the quantity is < 10.

i.e.

IF QUANTITY < 10 THEN

COLOR THE RECORD TO RED.

Thanks in advance.

Lookup the UPDATEFORECOLOR command. Red = 255, but you can also look up the RGB color scheme (they do it differently than most languages I’ve seen) in the C/SIDE Help in the NAV client. You can’t update a whole line with one command, though. You’ll have to add code to every column’s OnFormat trigger using the above command.

Thanks.

But i don’t want to color forecolor i want to color the background of the text box to be red not the text.

I don’t think we can change background color dynamically except through property. [:(]

Correct, background color can not be changed dynamically.