By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Determining where a control is on a form; header, detail, or footer

P: n/a
Is there a way to determine which section of a form a control is located
in code....besides using the tag property?

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Salad" <hi**********@ranch.com> wrote in message
news:3F***************@ranch.com...
Is there a way to determine which section of a form a control is located
in code....besides using the tag property?


Use the .Section Property of the control

Select Case Me.Text0.Section
Case 0 'acDetail Form detail section or report detail section
Case 1 'acHeader Form or report header section
Case 2 'acFooter Form or report footer section
Case 3 'acPageHeader Form or report page header section
Case 4 'acPageFooter Form or report page footer section
Case 5 'acGroupLevel1Header Group-level 1 header section (reports
only)
Case 6 'acGroupLevel1Footer Group-level 1 footer section (reports
only)
Case 7 'acGroupLevel2Header Group-level 2 header section (reports
only)
Case 8 'acGroupLevel2Footer Group-level 2 footer section (reports
only)
End Select

--
Jeff Frent
Gargoyle, Inc.
www.gargoyleinc.com
Nov 12 '05 #2

P: n/a

Jeff Frent wrote:
Use the .Section Property of the control

Select Case Me.Text0.Section
Case 0 'acDetail Form detail section or report detail section
Case 1 'acHeader Form or report header section
Case 2 'acFooter Form or report footer section
Case 3 'acPageHeader Form or report page header section
Case 4 'acPageFooter Form or report page footer section
Case 5 'acGroupLevel1Header Group-level 1 header section (reports
only)
Case 6 'acGroupLevel1Footer Group-level 1 footer section (reports
only)
Case 7 'acGroupLevel2Header Group-level 2 header section (reports
only)
Case 8 'acGroupLevel2Footer Group-level 2 footer section (reports
only)
End Select


Thanks much.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.