ms+access+course/ - Make forms "pop up" above other windows but ALWAYS the same size

Resolved · Low Priority · Version Standard

Mon 26 Nov 2007, 14:50 Delegate Julie said...

Julie has attended:
Access Advanced course
Access VBA course

Make forms "pop up" above other windows but ALWAYS the same size

I am trying to use some forms that need to pop up in front of the rest of the windows which i can do by using the "Pop Up" form property set to yes. However they always seem to be different sizes when they pop up and i need them to be the same size every time.

Any advice?

Tue 27 Nov 2007, 10:22 Edited on Tue 27 Nov 2007, 10:23 Trainer Richard said...

RE: Make forms "pop up" above other windows but ALWAYS the same

Hi Julie

Use the MOVESIZE method or Macro command.

To run the MoveSize action in Visual Basic, use the MoveSize method of the DoCmd object.

DoCmd.MoveSize(Right, Down, Width, Height)

This will allow you to set the location of the window, as well as the size.

The following example moves the active window and changes its height, but leaves its width unchanged:

DoCmd.MoveSize 1440, 2400, , 2000

To move a window without resizing it, enter values for the Right and Down arguments but leave the Width and Height arguments blank.

To resize a window without moving it, enter values for the Width and Height arguments but leave the Right and Down arguments blank.

Regards

Richard
Microsoft Office Specialist