Change textfield font colour if date() => Date Value

[Brianfree]

Hi i want to change a textfield font colour if todays date() => a Date in a textfield on continuous form.

I have tried this but it only works for one row not all rows?

Where am i going wrong?

Many thanks,

BF

 

[jamaarneen]

Hi BF,

Try to do this with 'Conditional Formatting' on the textbox.
when the textbox is selected, go format > conditional formatting...

Hope this will help you
Ja

 

[TheAceMan1]

How are ya Brianfree . . .

In conditional formatting your [blue]expression would be[/blue]:

[blue]Expression Is [purple]Date()>[B][I]YourTextboxName[/I][/B][/purple]][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886