continous forms and conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All
I have a continous form which lists supplier names together with a date
field + other bits. I want to change the back color of the date field to
say red if the date is history and some other color if the date is not. Its
Friday and my brain is not working so please help me to crack this one.

Any suggestions

TIA
johnb
 
John

By History I assume you mean older than today. If so try this.

In the Conditional Formatting form use :-

Expression Is [DateField]<Date()

Change the name DateField to the name of your date field. Note that
Date is followed by open and close brackets and not 0.

HTH

Peter Hibbs.
 
Hi Peter
Thank you for the missive. So simple when the brains' in gear.

kind regards
johnb

Peter Hibbs said:
John

By History I assume you mean older than today. If so try this.

In the Conditional Formatting form use :-

Expression Is [DateField]<Date()

Change the name DateField to the name of your date field. Note that
Date is followed by open and close brackets and not 0.

HTH

Peter Hibbs.

Hi All
I have a continous form which lists supplier names together with a date
field + other bits. I want to change the back color of the date field to
say red if the date is history and some other color if the date is not. Its
Friday and my brain is not working so please help me to crack this one.

Any suggestions

TIA
johnb
Click to expand...
Click to expand...
 
Back
Top