Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
Course Of The Month
3 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Set Subform's Top Property via VB Code
Posted on 2013-01-05
Hello all!
I have a Form (not a tabbed form this time). On that Form I have 4 subforms. Based upon a Frame option group certain of these subform's will be made visible. However I would like to set the Top property of the subform when the AfterUpdate of the option group is selected.
The Mainform has a header. Where I want the subform Control to appear is at 1.635" down within the Detail section. So I attempted.
Me![subform].Top = (me.formHeader.Height + 1.635)
However, this doesn't work. Is there a way I can set that Subform's Top setting with Code????
I have a Form (not a tabbed form this time). On that Form I have 4 subforms. Based upon a Frame option group certain of these subform's will be made visible. However I would like to set the Top property of the subform when the AfterUpdate of the option group is selected.
The Mainform has a header. Where I want the subform Control to appear is at 1.635" down within the Detail section. So I attempted.
Me![subform].Top = (me.formHeader.Height + 1.635)
However, this doesn't work. Is there a way I can set that Subform's Top setting with Code????
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
4 Comments
Active today
Also, I don't think you need to include the height of the header section.
The measurement (I think) begins in the section where your control is located.
Me.subform.Top = 1.635 * 1440
The measurement (I think) begins in the section where your control is located.
Me.subform.Top = 1.635 * 1440
That was it!!!!!!!!!!!
And you ARE in fact correct .... the height didn't need to be in the formula!!!!!
Thanks mbiz
And you ARE in fact correct .... the height didn't need to be in the formula!!!!!
Thanks mbiz
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
Suggested Courses
Course of the Month3 days, 20 hours left to enroll
690 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.