report macro - most Recent Date

[multipleintell]

I want to make a macro on the Print Event of a report header that will set the Value of the "last" date in the list to a different forecolor. How can this be done?

Thanks
Melissa

 

[GingerR]

you could use Conditional Formatting instead (acc2k and above).

choose your field and choose menu item FORMAT+CONDITIONAL FORMATTING.

choose Field Value Is Equal To

then in the equation, figure out the 'last' date by using

dmax("DateFieldName","TableName")[code]

{Fill in your field name and table name}

then choose whatever colors or whatever that you want