move a form 1

[scottian]

Ive created a database with a user form set to popup and auto center. However this isnt good enough for some users and they want the form to popup in the top right corner of the screen. is this possible? using Access 97.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks

 

[JoeriMJ]

Calculate screen width and height, then positioning your form using top and left functions? In VB, there's a function to retreive the screen dimensions, so it's possible there's one for VBA. Try a google search

Greetz,
Joeri

 

[Remou]

Is MoveSize available in '97?

DoCmd.MoveSize 144, 240

 

[JoeriMJ]

Why 144, 240 ?
Is this the same for every screen resolution ?

Greetz,
Joeri

 

[Remou]

Random small numbers. The units for the arguments are twips.

 

[scottian]

Thanks Remou.

"Children are smarter than any of us. Know how I know that? I don't know one child with a full time job and children."...Bill Hicks