Rocky Smolin
rockysmolin at bchacc.com
Wed Sep 22 00:32:22 CDT 2010
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 ------------ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com