I do a report in ACCESS 2000. In the footer of the report I have 3 fields and the number that appears in each one is calculated in the code of the report. When I preview the report all the numbers are correct, but when I print the reports all the numbers in those fields are doubled. I have put the code in both Format and Print, but still the same problem. I would appreciate any hints to solve the problem.
Rgds

Does it print correctly if you do not preview the report first but just print?

If you preview the report, and everything is correct, then you print from the preview and the values double. This is normally caused by using variables that are not initialed back to 0 when the report starts. When you print from a preview, the report is actually run again so all the code runs twice.

Boyd
Access Based Accounting/Business Solutions developer.

i know this may sound simple, but make sure you have the latest service pack for your version of OFFICE.

"Life is a Database"

I agree sdilucca. With Access 2000 you have at least SP3, and JET SP8. If you do not have at least SR1 and Jet SP5, Access 2000 is very unstable.

Boyd
Access Based Accounting/Business Solutions developer.