Form loading time slows down if it can't fit on screen vertically (1 Viewer)

Hello1

Registered User.
Local time
Today, 04:46
Joined
May 17, 2015
Messages
271
For me something new and pretty weird.
If I resize the access window so that my form controls cant completely fit on screen vertically the loading time of the form and moving between records increases from like 0.5 seconds to 5 to 10 seconds.
Any idea why is this happening and is the only way of preventing it to fit the controls vertically, meaning no scrollbar?
Access version is 2007
Thanks
 

isladogs

MVP / VIP
Local time
Today, 02:46
Joined
Jan 14, 2017
Messages
18,209
I can't explain the slow loading you are experiencing
In order to fit this on a single screen, you need to redesign your form or increase the resolution.
You could also consider the use of automatic form resizing. See my extended article & example app:

NOTE: Some features are for Access 2010 or later so won't work in your version
 

Hello1

Registered User.
Local time
Today, 04:46
Joined
May 17, 2015
Messages
271
Looks interesting, I was thinking about doing something similar but didn't find time to do so.
I get unrecognized database format error when I try to open the AFR_v375.accdb but will try another day with access 2010 and check it out more detailed. Thanks for the share!
 

isladogs

MVP / VIP
Local time
Today, 02:46
Joined
Jan 14, 2017
Messages
18,209
Hopefully you will be able to try it in A2010 or later
Unfortunately, it will be a lot of work for me to alter it to work in A2007.

The original version from 2003 is an MDB file and will work in A2007, but lacks many features available in the latest version
 

Users who are viewing this thread

Top Bottom