I trying again but nothing...

[bigdad]

hi is me, bigdad again:

I trying to use the DynamicForecolor again with the IIF() but nothing. My problems is with a date in specific. How I can do the expression to evaluate with IIF() if a date is empty (ctod("&quot).

If somebody can helpme be wellcome, please is urgent!!!

 

[csr]

I have never heard of DynamicForecolor. It isn't a property is it ?

Let me see if I can interpret your statement.
You are trying to change the Forecolor property of a textbox assigned to a date field depending upon whether or not the date is blank.

If so, assign the forecolor in the refresh method or the lostfocus method.

Don
dond@csrinc.com

 

[weedz]

Here is a sample of the use of a dynamicforecolor:

I put this in the grid class's Init()

THIS.SETALL("DynamicBackColor", "IIF(RECNO(THIS.RecordSource) = THIS.rec_no, 8388608, 16777215)", "Column&quot
THIS.SETALL("DynamicForeColor", "IIF(RECNO(THIS.RecordSource)= THIS.rec_no, 16777215, 0)", "Column&quot

So in your case, you could try it with your empty date.

THIS.SETALL("DynamicBackColor", "IIF(EMPTY(MyDateField), 8388608, 16777215)", "Column&quot
THIS.SETALL("DynamicForeColor", "IIF(EMPTY(MyDateField), 16777215, 0)", "Column&quot

HTH, Weedz (Wietze Veld)

http://www.crowncap.demon.nl

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best. - Steve McConnell