OnFormat Event

[L.M. via AccessMonster.com]

I am using MS Access 2000. I have created a table of contents for a report,
and I am updating the pages in the OnFormat Event (I don't want to do it on
the OnPrint because they may be viewing it more than printing it) The
OnFormat Event does not seem to fire when you display the report in
PrintPreview unless you physically forward through the report pages to the
end. According to the documentation, the onFormat event should execute on
PrintPreview. Has anyone run across this?
Thanks in advance.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200507/1

[Rick Brandt]

L.M. via AccessMonster.com wrote:

I am using MS Access 2000. I have created a table of contents for a
report, and I am updating the pages in the OnFormat Event (I don't
want to do it on the OnPrint because they may be viewing it more than
printing it) The OnFormat Event does not seem to fire when you
display the report in PrintPreview unless you physically forward
through the report pages to the end. According to the documentation,
the onFormat event should execute on PrintPreview. Has anyone run
across this?
Thanks in advance.

I believe that is the normal behavior. Try adding a control that uses the
[Pages] property. In order to populate that Access will format the entire
report to get the page count and then return to the beginning and start
again. This does make the report slower to open so I always avoid using
[Pages] on large reports.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com