INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Troubleshooting

Why Do My Calculations Change from Preview to Print? by Sameal
Posted: 4 Jan 02

If you use VB behind your reports to build calculations then you may encounter this problem much the same way I did. It all happened when I used three variables to hold accumulation totals so that when the report got to the footer, those three variables held the totals to display.

The phenomenon occured when I previewed the report and all my totals were correct, but after I clicked Print the totals doubled exactly to the penny.

After a some thought I figured out that the Reports must calculate twice to print. Once to create the preview and then a second time when printing. The problem was that the accumulation variables were being added to twice.

The solution is to provide correct initialization of your variables. They must be initialized first when the report is first opened, and then a second time when the report is sent to the printer. The names of these two events are Report_Open and Report_Page.

Back to Microsoft: Access Reports FAQ Index
Back to Microsoft: Access Reports Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close