assign variable to text box in report

[pungentSapling]

I have a global variable that I want to have show up in a text box on the bottom of a report.

this (below) works fine if I preview the report , or preview and then print from the preview.

Private Sub Report_Activate()
Me.txtFile.Value = varTransNumber
End Sub


but if use the acViewNormal to open the report (direct to the printer) the textbox never gets populated.

if I move the code to the on open event then I get an error saying that I cant "assign a value to this object"

I have tried the on page event also and it does not populate the text box either.

any suggestions?
Thanks

 

[Rich]

Use the OnPrint event

 

[pungentSapling]

thanks..I used the on format option and it worked like a charm.

You guys are the greatest!


p p