How to obtain the location of a specified control in a form in Acc

  • Thread starter Thread starter form control location Access
  • Start date Start date
F

form control location Access

I've already defined these variables:
Microsoft.Office.Interop.Access.Application oAccess,
Microsoft.Office.Interop.Access.Form oForm,
Microsoft.Office.Interop.Access.Controls oCtls, and had assigned them correct
values;

Now I can use a method to get the properties of a specified control such as
Caption,Font and so on like this: Microsoft.Office.Interop.Access.Lable
lable=(Microsoft.Office.Interop.Access.Label)oCtls["LableName"];
But I don't know how to determine whether a control is located in a
specified area(eg. form header/footer, page header/footer or form body), or
in another way, how to examine the target area to confirm whether my target
control exists?

Thank you for your kindly help!
 
Look at the Section Property in help. I found it by entering

MsgBox Me.Text0.Section


in a procedure, then clicking on "Section" and pressing the {F1} key.



From Help:

"You can use the Section property to identify a section of a form or report
and provide access to the properties of that section. You can also identify
controls by the section of a form or report where the control appears."


HTH
 
Back
Top