Position form on screen, when open it

[an]

Hello!
How is possible display on screen a form, with
coordenates "pre-defined" for us, when open it.
For exemple, lower right corner.
Thanks in advance.
an

 

[Mark]

Hi,

Look up the DoCmd.MoveSize method.

The following example moves the active window and changes its height, but
leaves its width unchanged:
DoCmd.MoveSize 1440, 2400, , 2000
--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Bruce]

Use the MoveSize method in the form's On Open event. See
Help for more. The general approach is as follows:
Open the form in design view. Double click the square
with the small square inside it at the top right of the
form, or click View > Properties. Click the Events tab,
click On Open, click the three dots that appear, click
Code Builder, Click OK. At the blinking cursor in the
code window that appears, enter:

Docmd.MoveSize 1000, 1000

Close the code window, and switch to Form View. The
larger the first number, the farther the form will be from
the left edge. The second number is the distance from the
top. Modify these numbers to suit your needs. You could
also add two more numbers separated by commas to set the
size of the form, but don't bother if your form is opening
at the correct size. There is a way of determining
exactly what numbers to use in the code, but from what I
can figure out it is pretty complicated, so I just
experiment until it looks right.

 

[an]

Thanks for your reply and help.
an

-----Original Message-----
Use the MoveSize method in the form's On Open event. See
Help for more. The general approach is as follows:
Open the form in design view. Double click the square
with the small square inside it at the top right of the
form, or click View > Properties. Click the Events tab,
click On Open, click the three dots that appear, click
Code Builder, Click OK. At the blinking cursor in the
code window that appears, enter:

Docmd.MoveSize 1000, 1000

Close the code window, and switch to Form View. The
larger the first number, the farther the form will be from
the left edge. The second number is the distance from the
top. Modify these numbers to suit your needs. You could
also add two more numbers separated by commas to set the
size of the form, but don't bother if your form is opening
at the correct size. There is a way of determining
exactly what numbers to use in the code, but from what I
can figure out it is pretty complicated, so I just
experiment until it looks right.
.

 

[an]

Thanks for your reply and help, too.
an

-----Original Message-----
Use the MoveSize method in the form's On Open event. See
Help for more. The general approach is as follows:
Open the form in design view. Double click the square
with the small square inside it at the top right of the
form, or click View > Properties. Click the Events tab,
click On Open, click the three dots that appear, click
Code Builder, Click OK. At the blinking cursor in the
code window that appears, enter:

Docmd.MoveSize 1000, 1000

Close the code window, and switch to Form View. The
larger the first number, the farther the form will be from
the left edge. The second number is the distance from the
top. Modify these numbers to suit your needs. You could
also add two more numbers separated by commas to set the
size of the form, but don't bother if your form is opening
at the correct size. There is a way of determining
exactly what numbers to use in the code, but from what I
can figure out it is pretty complicated, so I just
experiment until it looks right.
.

 

[Bruce]

You're welcome. I learned a lot of stuff here in the
first place, so I like to give it back when I can.