hi all,

i am generating a cursor dynamically whose column names vary depending on the choices made by the end-user of the software. the column names vary from PER01, PER02, PER03...upto PER12 and they all contain only NUMERIC data. The values contained in this cursor i am displaying in a grid.

Depending on the columns chosen by the user, i store the column name in a form variable - ThisForm.cMonthPercent - along with the join condition - for example, "per01 < 50 Or per02 < 50 or per03 < 50" (the join condition will always contain only the < sign).

i try to use this form variable in the following command -

ThisForm.grdDetails.SetAll("DynamicForeColor","IIF(ThisForm.&cMonthPercent,RGB(255,0,0),RGB(0,0,0))","Column")

but, i cannot get it to work.

What i want to achieve is that if there are any values in the grid that are less than the number 50 (PER01 < 50 Or PER02 < 50 Or PER03 <50), those numbers only should be highlighted in RED whereas the other numbers in the grid should be in BLACK.

With reference to te above example, if any value in PER01 or PER02 Or PER03 is less than 50, it should be be in RED colour.

Can someone help me achieve this result.

With sincere thanks in advance.