Flag conditional formating

  • Thread starter Thread starter SAC
  • Start date Start date
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.
 
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.
 
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...
 
Back
Top