Conditional formatting question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to have records with dates in the next 7 days in bold type so that
appointments associate with these dates stand out. Can you please help?
 
Open the report in Design View. Right click the textbox that holds the date
and choose Conditional Formatting. Set the first drop down to "Field value
is", the second to "Between", the first textbox to "Date()", and the second
textbox to "Date()+7" (all without the quotes). Click the Bold button on
that line and click Ok. Preview the report and see if it worked. Verify the
7th day is doing what you want. You may need to adjust the 7 to a 6 or 8. If
there is a time value in the date field, that may cause a problem also. If
there is, let me know.
 
This seems to work fine... but is there any way I can also apply the same
formatting to other feieds in the same row which are NOT associated with the
date i.e. the name of the person I have an appointment with and the time the
appointment is scheduled? (Time is a separate field.)
 
Yes, instead of using Field Value Is, use Expression Is and type in an
expression that refers to the date field.

Example:
[DateField]>= Date() And [DateField] < Date() + 8

This is also how it would have been handled if you had a time component
stored in the field. Instead of checking for <=7, check for <8, that way
anytime of day on the 7th day will be within the range.
 
Back
Top