ms+access+course/ - make forms pop up

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms+access+course/ - Make forms "pop up" above other windows but ALWAYS the same size

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

resolvedResolved · Low Priority · Version Standard

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?

Edited on Tue 27 Nov 2007, 10:23

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


Server loaded in 0.09 secs.