Determine which section of a form contains a control

[Me.Frustrated = True]

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.

 

[Jeff Boyce]

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.

 

[Clifford Bass via AccessMonster.com]

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]

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.

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

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.

--



.

 

[Clifford Bass via AccessMonster.com]

Hi,

You are welcome.

Clifford Bass

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.

 

[Jeff Boyce]

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.

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.

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

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.

--



.