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

[Salad]

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

[Jeff Frent]

"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

[Salad]

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.