Print Page | Close Window

Form_DynamicSizingOfSubform

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=441
Printed Date: 13 Dec 2017 at 4:22am


Topic: Form_DynamicSizingOfSubform
Posted By: A.D. Tejpal
Subject: Form_DynamicSizingOfSubform
Date Posted: 12 Dec 2008 at 5:20pm

Form_DynamicSizingOfSubform
Sample Db - Explanatory Notes

    This sample db demonstrates run time manipulation of subform control height. It covers both views for the subform, i.e. continuous form as well as datasheet. The views can be toggled from one to the other by clicking a command button.
 
    Depending upon the layout for a specific form, it is preferable to specify the maximum number of rows upto which the subform height should expand. This figure can be entered in text box named TxtMaxLines. Default value for max lines is set at 6. While stepping through the records on main form, if the records in linked subform happen to exceed MaxLines, further increase in the height of subform is kept in abeyance. At this stage, vertical scroll bar is inserted. As and when the subform records are again within limits, the vertical scroll bar is removed and the height of subform control adjusts suitably.
 
    In case of datasheet view, care has been taken to dynamically adjust the column widths so that no awkward blank space is visible at right in lieu of scroll bar when it is not needed.
 
    Two alternative ways are available for navigating through records on the main form. The user can either use the normal navigation buttons or the unbound combo box for jumping to any desired record. The combo box is suitably synchronized so that even while using normal navigation buttons, the value displayed in combo box matches the current record.

Reference required - Nothing extra.

Version - Access 2000 file format

Download File >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Form_DynamicSizingOfSubform.zip - uploads/37/Form_DynamicSizingOfSubform.zip
 
 


-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window