Access 2003 doesn't have the On Load Event for Reports?

[ions]

Dear Access Expert.

I am little confused. When I create a report in Access 2003 there is no On Load Event for the Report? The On Load event does exist in Access 2007.

How do I manipulate the report based on the loaded data if there is no ON Load event? If I put the code in the On Open event the data is not yet loaded into the report and I can't write my VBA.

Thank you.

 

[boblarson]

The On Load event for Reports didn't come into being until Access 2007.

What are you trying to accomplish in that event? Most of the time you probably will want the On FORMAT event of the section where the controls are located that you want to control.

 

[ions]

Hi Bob,

Thanks for your response.

I want to change a label in the report Header based on the data in a field that is also in the header.

If Me![InvoiceDate] > #1/1/2011# then

Me!lblHST = "1234"

Else

Me!lblHST = "5698"

End If

Thank you for your help.

 

[boblarson]

Hi Bob,

Thanks for your response.

I want to change a label in the report Header based on the data in a field that is also in the header.

If Me![InvoiceDate] > #1/1/2011# then

Me!lblHST = "1234"

Else

Me!lblHST = "5698"

End If

Thank you for your help.

Yep, it would go in the Report Header's On Format event.