Error in report only the first time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am generating a report using docmd in access 2003 and whenver the report
is run for the first time the formatting goes off and it comes up all
unformatted with some data missing.
But from the second time it works perfectly.
Has anyone encountered such a problem before.
Any help would be appreciates since I am a newbie

thanks,
rin
 
No, haven't seen that.

Just the first time? If you mean the first time ever, you might try saving
and closing it before opening.

If you mean the first page every time it runs, and you have some code in the
report's events, you may have something that is not initialized properly.

It could be a faulty printer driver. Access uses the metrics from the
printer driver to lay out the report. To test this idea, try temporarily
choosing a completely different printer as your default printer, and see if
the problem vanishes.

As always, it's worth turning Name AutoCorrect off so Access does not
confuse the fields/tables. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database to get rid of this junk:
Tools | Database Utilities | Compact
Explanation of why:
http://allenbrowne.com/bug-03.html
 
Back
Top