A.D. Tejpal
adtp at airtelmail.in
Wed Sep 22 02:44:08 CDT 2010
Rocky,
Could you kindly open my sample db, click on various command buttons on switchboard form so as to open the demo forms one by one and advise whether the behavior is found OK ?
You can also test the custom resize feature by dbl clicking a demo form's blank area. It should take only a few minutes.
Best wishes,
A.D. Tejpal
------------
----- Original Message -----
From: Rocky Smolin
To: 'Access Developers discussion and problem solving'
Sent: Wednesday, September 22, 2010 11:02
Subject: Re: [AccessD] Resizing of forms to suit screen resolution in force
A.D.:
I have had a problem with 'jumping' screens - forms that seem to jump a
millimeter or so when they open - or maybe flash and repaint. It only
happens with mdes not mdbs, and I have always thought it had to do with the
form resizing code I got from the ADH.
Do you know about this and does your method eliminate this problem?
MTIA
Rocky Smolin
Beach Access Software
858-259-4334
Skype: rocky.smolin
www.e-z-mrp.com
www.bchacc.com
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, September 21, 2010 10:09 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Resizing of forms to suit screen resolution in force
The topic of automated resizing of forms so as to suit current screen
resolution comes up from time to time.
My sample db named Form_Resize (in Access 2002-2003 file format,
reference: DAO 3.6), meant to cover this requirement, has been uploaded to
Rogers Access Library. Link -
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
Apart from automatic resizing to suit current screen resolution, the
sample offers custom resizing (up or down in steps of 5 percent) of any
given form, if so desired by the user, with the option to freeze the custom
size so that thereafter the form opens to custom size (over-riding the size
dictated by actual resolution). At any stage the behavior can be reset to
normal (i.e. automatic resizing to suit current resolution).
Resizing is effected through a self contained class. Six styles of demo
forms are included in the sample as follows:
(a) Simple controls - all free to float and resize.
(b) Simple controls - with certain controls having tag property settings
for locking their position and / or size.
(c) Combo box and list box.
(d) Nested subforms - Continuous.
(e) Nested subforms - Datasheet.
(f) Tab control having (i) Nested subforms and (ii) Option group. Also -
an option group directly on the form.
I shall be thankful if interested members could kindly make it
convenient to run the sample and confirm whether any aspects need further
tweaking. Explanatory notes are provided in file Notes.htm accompanying the
sample.
Best wishes,
A.D. Tejpal
------------