By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

OnFormat Event

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.