How can I resize my form when I open it?

F

fredg

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.
 
Top