Conditional Formatting In Continous Form

[Guest]

Hi All,

I wanted to make a Font Colour of a field "EventDate" turn red when the date
is <=Date(). I was able to make this happen using conditional formatting,
however my next issue is this.

I would like all the other fields in the same row also red, i assume this
can be done using the expression formatting, but can't seem to get the
expression correct.

I tried the following:

IIf(EventDate)<=Date()

then i set the font to red.

Can anyone assist PLEEEEEZE it's driving me nuts.

GregInOz

 

[Guest]

Try without the IIf

[EventDate]<=Date()

 

[Guest]

Thanks Ofer,

Works Perfectly!


GregInOz

Try without the IIf

[EventDate]<=Date()

--
Good Luck
BS"D

Hi All,

I wanted to make a Font Colour of a field "EventDate" turn red when the date
is <=Date(). I was able to make this happen using conditional formatting,
however my next issue is this.

I would like all the other fields in the same row also red, i assume this
can be done using the expression formatting, but can't seem to get the
expression correct.

I tried the following:

IIf(EventDate)<=Date()

then i set the font to red.

Can anyone assist PLEEEEEZE it's driving me nuts.

GregInOz