Hello,
I have a main form consisting of a Header, Detail and Footer.
The Detail consists of a Continuous Form of records. Associated with
each record is a "Select" Button for Selection.
The Footer contains a Subform.
On opening the form, the height of the Footer is reduced to show only
the "Exit" button for the Main Form. The Subform is 5 Twips high and
the form's visible property is set to false - for all practical
purposes, it is a blank real estate in the Footer.
Again on Opening - the Detail shows the Continuous Form of records.
To better handle the form, I determine if the number of records being
sought to be displayed is more than a fixed number - say 4. If so,
then I fix the Height of the Detail to a calculated value which is
based on the Height, RowHeight and FooterHeight.
On Clicking one of the select buttons:
The record associated with that entry (key value), is loaded into the
subform and the height of the subform is increased to display a
continuous form again.
NOW MY QUESTIONS:
I have encountered so many height related variables and I would like
to know what each of these variables are:
Me.Section(0).Height
Me.Section(1).Height
Me.Section(2).Height
Me.Footer.height
Me.Header.height
Me.Detail.height
What variable should I use for the Row Thickness? As of today, when
the number of records is more than my fixed number (4), then I
programmatically change the detail height to that which requires
displaying 4 records. My problem is somewhere I am missing a few
twips so that the upper portion of the select button is visible.
To complicate matters, I have a header and footer in the subform too!
hope someone can help.
Regards,
Uttam