Microsoft Access VBA Programming for the Absolute Beginner

Repositions and/or resizes an object window.

Syntax

DoCmd.MoveSize [Right][, Down][, Width][, Height]

with the following parameters:

Right

The new horizontal starting position of the window, expressed as the number of twips from the main Access window’s right edge.

Down

The new vertical starting position of the window, expressed as the number of twips from the main Access window’s top edge.

Width

The new width of the window in twips.

Height

The new height of the window in twips.

Comments

• Although all arguments are optional, at least one argument must be included or an error results.

• If any arguments are omitted, the window’s current value is used.

• A twip is 1/20 of a point. There are 1440 twips per inch.

• To size a form so its contents fit exactly, use the RunCommand method of the Application object as follows:

  RunCommand acCmdSizeToFitForm