Conditional formatting question

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?
--
Thanks for your time!

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.

--
Wayne Morgan
MS Access MVP


"NC_Sue" wrote in message
...
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?
--
Thanks for your time!

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.)
--
Thanks for your time!


"Wayne Morgan" wrote:

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.

--
Wayne Morgan
MS Access MVP


"NC_Sue" wrote in message
...
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?
--
Thanks for your time!

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.

--
Wayne Morgan
MS Access MVP


"NC_Sue" wrote in message
...
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.)
--
Thanks for your time!


"Wayne Morgan" wrote:

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.

--
Wayne Morgan
MS Access MVP


"NC_Sue" wrote in message
...
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?
--
Thanks for your time!