Re: Very slow Zoom Box operation.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks, I'll work through this.

Access97 & Access2000 were much faster than
Access2003

Regards,Frank


"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
wrote in message
news:eaCX8LZRGHA.5296@xxxxxxxxxxxxxxxxxxxxxxx
Frank, it should be nearly instantaneous.

Make sure the Name AutoCorrect boxes are
unchecked under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html
Then compact the database:
Tools | Database Utilities | Compact

If that does not help, work though the rest
of the issues Tony Toews has listed in his
Performance FAQ for Access:

http://www.granite.ab.ca/access/performancefaq.htm

--
Allen Browne - Microsoft MVP. Perth,
Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at
mvps dot org.

"Frank Martin" <fm@xxxxxxxxxxxxxx> wrote in
message
news:er6NuOXRGHA.5728@xxxxxxxxxxxxxxxxxxxxxxx
I have just upgraded to Access2003 from
Access2000.

I have WindowsXP pro MediaCentre.

I have a new dual-core Pentium IV and 1Gb
RAM.

My invoice form has a subform with a
data*** for "InvoiceLines".

One of the fields here is for comments to
be shown on the invoice body, and I have
coded for a zoom box to popup when the
cursor enters this 'comments' field.

The zoom box appears quickly enough, but
is extremely slow to shut when the OK
button is pressed.

Yhe "onEnter" property has the following
code:

<DoCmd.RunCommand acCmdZoomBox>

Can someone tell me why is so slow in
Access2003?

Please help, Frank

PS. I have already shut down the
Subdatasheets using the
"TurnOffSubDataSheets" code published in
the MS KB.





.

Quantcast