conditional formatting of date in query

  • Thread starter Thread starter amanda redmond-neal
  • Start date Start date
A

amanda redmond-neal

hi. i have a query that, in conjuction with a
subdatasheet, serves as a "to do" list, complete with due
dates and check boxes for completed tasks. rather than
having to read it closely each day, i want to arrange for
the due dates that are today or earlier to become blue. i
understand that this is possible using conditional
formatting -- my question is how to apply conditional
formatting to a query expression, as opposed to the design
view of a form or report (which is all the app. help
mentions).

in design view, the due dates take the form of:

Send Packets: Format$(First([Booking Date]-42),"mm/dd/yy")
or
Payment Due: Format$(First([Booking Date]-14),"mm/dd/yy")
or
Alert Media: Format$(First([Booking Date]-7),"mm/dd/yy")

you get the idea. what can i add into the above
expressions to make the text appear blue if the dates are
today or earlier and black if they are yet to come?

thanks for any suggestions, --amanda
 
rather than
having to read it closely each day, i want to arrange for
the due dates that are today or earlier to become blue. i
understand that this is possible using conditional
formatting -- my question is how to apply conditional
formatting to a query expression, as opposed to the design
view of a form or report (which is all the app. help
mentions).
Click to expand...

You can't.

Base a Form on the query, and look at the Form (with conditional
formatting) rather than the query datasheet. Datasheets (table or
query) have very limited functionality and should not routinely be
used for data display or data entry.
 
Back
Top