Flag conditional formating

S

SAC

I'm using contional formatting for several controls on a form to show that a
record is past a time deadline. If it is, I'd like to flag another control
to sort the list of records by.

Is there a property on the control that is set when a contitional format is
true so I can flag it?

Thanks.
 
A

Allen Browne

To sort the results, you will need a field in the form's RecordSource.

Create a query to use a the RecordSource of your form.
Enter an expression into a fresh column in the Field row.
For example, if you want to compare the DateDue field to today:
IsDue: ([DateDate] < Date())

You can now perform some sorting on this expression.
 
S

SAC

Thanks Allen.

Allen Browne said:
To sort the results, you will need a field in the form's RecordSource.

Create a query to use a the RecordSource of your form.
Enter an expression into a fresh column in the Field row.
For example, if you want to compare the DateDue field to today:
IsDue: ([DateDate] < Date())

You can now perform some sorting on this expression.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

SAC said:
I'm using contional formatting for several controls on a form to show that
a
record is past a time deadline. If it is, I'd like to flag another control
to sort the list of records by.

Is there a property on the control that is set when a contitional format
is
true so I can flag it?

Thanks.
Click to expand...
Click to expand...
 
Top