How can I resize my form when I open it?

  • Thread starter Thread starter hanski
  • Start date Start date
hi.

How can I tell via VBA how big is a form I open and how it is
situated?

Hannu
Click to expand...

Look up the MoveSize method in VBA help.

Place the below code in the form's Open event.
It will position the form 2 inches from the left edge of the screen, 3
inches down from the top, and size it to 1.5 inches by 4 inches.

DoCmd.MoveSize 2*1440,3*1440, 1.5*1440,4*1440

Note: all measurments are in Twips, 1440 per inch.
 

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

Similar Threads

How can I send email via Access without opening Outlook? 1
How do I refresh links from Access to Sql server via ODBC? 1
How can I reset a calc-field? 2
How to have a correct size in a form? 2
How can I search part of text from a field in VBA? 1
Weeknumbers to calendar component? 3
Asking about hyperlink. 1
How can I move a menu to a new database? 2

Back
Top