>>I'm tring to set the font 1 cell of a column if a condition is met in another columns recordsource. Here is what I have.
>>thisform.grid1.column2.controlsource = "(IIF(ticketdata.loandate - (date()-loandate) > 90,thisform.grid1.column6.text1.FontStrikeThru=.T.,thisform.grid1.column6.text1.FontStrikeThru=.T.))"
>>
>>I want to check if Loandate is greater then 90 days back from the current date. If it is I want to turn on the fontstrikethru in that row of record in column 6. But not the hole column just the cell that the row is over 90days back from the current date.
>>
>>I notice that the date command doesn't work in the iif statement.\
>>
>>Thanks kelly
>
>Kevin,
>
>Use DynamicFontStrikeThru instead.
To guide further, simply put this in the DynamicFontStrikeThru property of the Column6 using PEM window of the Grid:
IIF(ticketdata.loandate - (date()-loandate) > 90,.T.,.F.)
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."