calculated control in header

[belovedcej]

I have a report which is not bound in the property but is instead bound in the code (on the open event of the report.)

All works fine except the calculated control I have in the report header. If I put that control in the page header, no problem - but apparently Access tries to calculate the stuff in the header before it triggers the open event.

I really want this control in the header so it doesn't repeat on every page - and I have never attempted to set the value of a text box in code and was hoping to avoid it.

Any ideas?

 

[belovedcej]

Never mind. I just went ahead and took care of it in VBA since there was plenty of info about that here.