Determine which section of a form contains a control - microsoft.public.access.formscoding

I'm trying to visualize a situation for which I'd need to locate a control (as opposed to already knowing where it was)... Help! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Me.Frustrated = True" <MeFrustratedTrue@discussions.microsoft.com> wrote in message news:299A070B-EB51-4370-B104-F0C42C784732@microsoft.com... > Is there a way to find out programmatically whether a control is in the > form's header, footer, or detail section? I can't see anything in the > control's properties that indicates this.

Hi, Certainly. Suppose a button named "Command10" with an On Click event: Private Sub Command10_Click() MsgBox Me.Section([Command10].Section).Name End Sub Clifford Bass Me.Frustrated = True wrote: >Is there a way to find out programmatically whether a control is in the >form's header, footer, or detail section? I can't see anything in the >control's properties that indicates this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

Thanks Clifford, this worked. For Jeff Boyce, I have a couple of functions that magnify and de-magnify all the controls and the "Details" section on a form for a vision-impaired user at the click of a button. I wanted to exclude all the controls on the header and footer in my code, and Clifford's suggestion worked. "Clifford Bass via AccessMonster.com" wrote: > Hi, > > Certainly. Suppose a button named "Command10" with an On Click event: > > Private Sub Command10_Click() > > MsgBox Me.Section([Command10].Section).Name > > End Sub > > Clifford Bass > > Me.Frustrated = True wrote: > >Is there a way to find out programmatically whether a control is in the > >form's header, footer, or detail section? I can't see anything in the > >control's properties that indicates this. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 > > . >

Hi, You are welcome. Clifford Bass Me.Frustrated = True wrote: >Thanks Clifford, this worked. >For Jeff Boyce, I have a couple of functions that magnify and de-magnify all >the controls and the "Details" section on a form for a vision-impaired user >at the click of a button. I wanted to exclude all the controls on the header >and footer in my code, and Clifford's suggestion worked. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

Thanks for the clarification. I learned something new today! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Me.Frustrated = True" <MeFrustratedTrue@discussions.microsoft.com> wrote in message news:DF6E56CD-5013-4F40-9145-85E39DC64F1D@microsoft.com... > Thanks Clifford, this worked. > For Jeff Boyce, I have a couple of functions that magnify and de-magnify > all > the controls and the "Details" section on a form for a vision-impaired > user > at the click of a button. I wanted to exclude all the controls on the > header > and footer in my code, and Clifford's suggestion worked. > > "Clifford Bass via AccessMonster.com" wrote: > >> Hi, >> >> Certainly. Suppose a button named "Command10" with an On Click >> event: >> >> Private Sub Command10_Click() >> >> MsgBox Me.Section([Command10].Section).Name >> >> End Sub >> >> Clifford Bass >> >> Me.Frustrated = True wrote: >> >Is there a way to find out programmatically whether a control is in the >> >form's header, footer, or detail section? I can't see anything in the >> >control's properties that indicates this. >> >> -- >> Message posted via AccessMonster.com >> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1 >> >> . >>

Similiar Articles:

Which control has focus? - microsoft.public.access.formscoding ...
Mark A. Sam wrote: >Is there a way to detect which control on a form has the focus? If you know which form contains the control, then use the form object's ...

Control Form form a Sub Form - microsoft.public.access.forms ...
... subform's Detail section ... check if form loaded and control on subform blank ... the main form (main form: A form that contains one or more subforms.) and subform control ...

can't see control in detail section when add Tab control ...
I cut my controls from my detail section of a form Added the Tab control - to the Detail section of the Form selected the TAB for first page- so Ta...

Record Selectors & Navigation Buttons: Set BackColor ...
Anybody know how to coerce the colors of a form's RecordSelectors section and ... guess, with a control ... on my site contains the required code. Simply substitute your form's ...

Text Box Control contains generated hyperlink - microsoft.public ...
Add a text box control to a form or report - Access - Office.com Add a ... You only need to know the name of the control that contains the hyperlink. ... datasheets as IDC ...

Combining forms with separate tab controls - microsoft.public ...
Each form contains a tab control. > > I would like to combine these two forms and incorporate ... I've posted this question in another section of this site, and I was asked ...

I am using a tree control (MSComctlLib.TreeCtrl.2) in a form ...
... node is that you put the textbox in the detail section of the form ... about a material that is clicked on in the tree control. The > form > is based on a query containing ...

FormatCondition - microsoft.public.access.formscoding
The control I want to set / clear the .visible property is in the form detail section, and I am using ... event procedure of the section > containing the control to ...

Moving Subform to Tab Control - microsoft.public.access.forms ...
A textbox or > other control on a Tab Page is - logically - just on the Form containing that > tab control. > > In contrast, a Subform is actually a different form ...

Tab control "bleed through" - microsoft.public.access ...
So, I put a tabbed control on my form. I then dragged the first section of controls onto the first ... and several TabPanels. Each TabPanel contains a User Control.

Controls 101: Repeating sections - InfoPath - Office.com
In this article, you'll learn about a useful InfoPath control called a repeating section (repeating section: A control on a form that contains other controls and that ...

Forms in HTML documents - World Wide Web Consortium (W3C)
An HTML form is a section of a document containing normal content, markup, special elements called ... and reset --> <!ELEMENT INPUT - O EMPTY -- form control ...

About sections of a form - Access - Office.com
... sections are represented as bands, and each section that the form contains is ... You determine where information appears in every section by placing controls (control: A ...

Access 2002 VBA Handbook - Microsoft Corporation: Software ...
... example, the Controls collection of a specific form contains the Control ... to refer to the form associated with a subform control. Height: Form section, report section, check ...

Control Object [Access 2003 VBA Language Reference]
The Control object represents a control on a form, report, or section ... including option button, check box, toggle button, and label controls. The tab control contains a ...

7/26/2012 8:58:23 PM