Flag conditional formating

[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.

 

[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.

 

[SAC]

Thanks Allen.

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.

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.