bold item in sub report

[Question Boy]

I have a report with a sub report which list dates for a given item.
Basically the user can enter a multide of dates for the item and they get
listed in the sub report. I am needing to make the date appear in bold if
the date is in the next 7 day windows and this only for the greatest date in
the sub report.

Can this be done and how?

Thank you,

QB

 

[Tom Lake]

I have a report with a sub report which list dates for a given item.
Basically the user can enter a multide of dates for the item and they get
listed in the sub report. I am needing to make the date appear in bold if
the date is in the next 7 day windows and this only for the greatest date in
the sub report.

Can this be done and how?

Thank you,

Look up conditional formatting. Here's a quick synopsis:

Go into the design of the subform, right-click on the field
you want made bold, then add your condition and what you
want to happen when that condition is met.

Tom Lake

 

[Question Boy]

But will that not apply to all the records and not just the last entry?

 

[Marshall Barton]

You have to use an effective set of conditions.

Add a text box (named txtLatest) to the subreport's header
section. Set its expression to =Max(datefield)

Then the condition would be like:

[datefield] = [txtLatest] And [datefield] >=Date()
And [datefield] <= Date()+7