Access Database and SP2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nancy - 26 Jan 2005 19:40 GMT

We have recently put Service Pack 2 on our computers.
Now when we try to preview a report in one of our Access
Databases (doesn't matter what version), it will just sit
there. Doesn't give us an error or anything. There is
code behind the button that is only the acPreview,
nothing special. Has anyone had this happen or know how
to resolve it?

Thanks in advance,
Nancy

Reply to this Message

Wayne Morgan - 26 Jan 2005 20:02 GMT

I have seen some strange things with the reports, but not this. What I have
seen usually involves the report trying to maximize when AutoCenter and
AutoResize are set to Yes. Turning these two off has solved the problem. You
may also want to make sure that you have Name Auto Correct turned off in the
Options, General tab. If you haven't applied all of the service packs for
your version of Office and Jet, that would also be a good thing to try. A
couple more things to try would be to change the Windows theme to Classic
and make sure that you have the most current video driver for you video
card.

Signature

Wayne Morgan
MS Access MVP

> We have recently put Service Pack 2 on our computers.
> Now when we try to preview a report in one of our Access
[quoted text clipped - 3 lines]
> nothing special. Has anyone had this happen or know how
> to resolve it?

Reply to this Message