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

  • Thread starter form control location Access
  • 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!
 
S

Steve Sanford

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top