find middle of screen (1 Viewer)

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #1

How can I find the middle of the screen, or at least the middle of the Access window ?
I want my login form to be placed in the middle of the screen.

Thank you,
Tal

 

J

JHB

Have been here a while

Local time

Today, 15:51

Joined

Jun 17, 2012

Messages

7,732

• Nov 20, 2014

• #2

What if you set the Form's property "Auto Center" to "Yes"?

 

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #3

JHB said:

What if you set the Form's property "Auto Center" to "Yes"?

Click to expand...

Thanks,
This should do the job.
Totaly forgot about it

 

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #4

I was too hapy too soon

AutoCenter cant be assigned in runtime (in VBA).
Since I change the form size based on some data it's not helping.

 

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 14:51

Joined

Sep 12, 2006

Messages

15,693

• Nov 20, 2014

• #5

but you would set autocentre for a login form at design time, wouldn't you?

you also have

runcommand accmdsizetofitform, instead of doing it manually.

It just makes the entire form visible at its default size.

 

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #6

Resizing the form at run time is easy, using InsideHeight and InsideWidth

is there anything similar to runcommand accmdsizetofitform to center form ?

 

Last edited: Nov 20, 2014

gemma-the-husky

Super Moderator

Staff member

Local time

Today, 14:51

Joined

Sep 12, 2006

Messages

15,693

• Nov 20, 2014

• #7

don't know. there are hundreds of runcommand arguments

I found a resource that listed them all the other day, and I can't find it now!


found it now. I remembered, I was looking at runcommand accmdremoveallfilters

http://access.mvps.org/access/RunCommand/list/listr.htm

 

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #8

Thank you
I'll try to find something

 

Frothingslosh

Premier Pale Stale Ale

Local time

Today, 09:51

Joined

Oct 17, 2012

Messages

3,276

• Nov 20, 2014

• #9

smig - there are a couple ideas for what you want HERE.

 

S

smig

Registered User.

Local time

Today, 16:51

Joined

Nov 25, 2009

Messages

2,209

• Nov 20, 2014

• #10

Thank you
Will try it when I get back to my machine.

I think I could kiss you for this.
But it will be just a little kiss on the chick. My whife is the jelous type. LOL


*** Edit ***
The code work perfectly
Only thing need to be changed is when looking for the hwnd = "Microsoft Access" to look also for CurrentDb.Properties("AppTitle") if can't find "Microsoft Access"

 

Last edited: Nov 24, 2014