continuous forms/conditional formatting

[chris]

I have a main form relating to a project with a subform for events in
that project which uses continuous forms. I want to highlight rows in
the subform when an event is overdue. I have a date field and a
"completed" check box on the subform. I want to test to see if the date
recorded for the event is earlier than the current date and "completed"
has not been ticked and then to change either the background colour for
the row or the colour of one of the displayed fields. Ideally I want to
have two stages to this, say if an event will be due within one week -
colour amber and then red when it becomes overdue.

So far I have only been able to get things to work when the particular
row is selected. Can anyone suggest a solution?
Chris

 

[Allen Browne]

Assuming Access 2000 or later, use Conditional Formatting (on the Format
menu in form design view.)

Since you have multiple criteria, you will need to use an expression, e.g.:
([Completed] = False) AND ([CurrentDate] < Date())

 

[Ron2006]

Sitting on that subform in design view.
Sitting on the field you want to color
Right click on field and chose "Conditional Formating"

If the test involves that field then create the test as the prompts
suggest.
If the test involves a different field then select expression and enter
code somthing like the following: [fieldnameoncontinuousform]="desired
value"
and then select the formating.

 

[chris]

Thanks for the advice from yourself and Ron
After I posted the request I discovered that option. I thought at first
that it would be necessary for the fields I was testing in the
expression to be on the form I was applying the formatting to. I have
since discovered that it isn't as long as they are part of the
underlying query.
Chris

 

[chris]

Thanks for the advice from yourself and Ron
After I posted the request I discovered that option. I thought at first
that it would be necessary for the fields I was testing in the
expression to be on the form I was applying the formatting to. I have
since discovered that it isn't as long as they are part of the
underlying query.
Chris