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 ------------