VBA ONPRINT for a FORM

[jackbee]

Anyone know how to trap an Onprint event for an
Access FORM

[gfrench]

This goes quite deep into vb, you have to do some subclassing, i recommend that you find a tutorial on subclassing, i believe there was one at http://www.vbsquare.com a while back. You will have to right your own function to handle events sent to the form, and any you know the form will handle or you dont want, you pass them back to the forms default fuction. I would use Spy++ to find out what message you are looking for first, then readup on subclassing, the theory is quite deep but once you get used to it, there really isn't that much to it.

Hope this helps,

[jackbee]

thanks for your interest gfrench
after playing around with a few ideas I came up with an easier solution:
I created a utility toolbar to replace the form's default bars, and coded stuff in the 'on action' property of the print button
seems nice and neat !!
thanks again