MS Access 2007 Form positioning

[jdspinelli]

Hello:

I am searching for a way to center forms in MS Access 2007. The VB6 way of setting the same property was "Startup Position" = 1 'Center Owner. I am aware of the AutoCenter, AutoResize and FitToScreen properties in Access 2007. I have AutoCenter set to "Yes", AutoResize set to "Yes" and FitToScreen set to "No". Can someone point me in the right direction?

Thank you,
Joe

 

[TheAceMan1]

How are ya jdspinelli . . .

Are you saying the [blue]AutoCenter[/blue] property isn't working?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jdspinelli]

Hey AceMan1,

I'm doing great, thanks! I hope you are well?

It would seem that AutoCenter isnt' working. I have it set to "Yes", yet the form opens full screen anchored to the top and left borders. Are there other properties I should be checking?

Thanks for your time!

 

[CharlieT302]

Try turning AutoResize off. I have had the same issues.

 

[CharlieT302]

One more thing.

To control the size, use the "On Open" event to size the height and width of the form.

Ex:
me.insideheight = 8000
me.insidewidth = 14000

Also, setting the Border Style to This keeps users from resizing (and then saving the setting) the form. It can still be maximized, though.

 

[CharlieT302]

I meant to say "Thin" for Border style.

 

[TheAceMan1]

jdspinelli . . .

Try setting the forms [blue]Pop Up[/blue] property to [blue]Yes[/blue].

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jdspinelli]

Thanks Charlie and AceMan,
I will put these changes in place and keep you posted.
VERY MUCH appreciated!
Thanks to both of you,
Joe

 

[jdspinelli]

Hello All:

I wanted to add a post just to get it on record. I found the following on msdn regarding the AutoCenter and AutoResize properties Charlie and AceMan referenced. The point is, position the form in Form View and save it.

Here is the link:

http://msdn.microsoft.com/en-us/library/bb240692(office.12).aspx

And here is what it says:
< If you make any changes in Design view to a form whose AutoResize property is set to No and whose AutoCenter property is set to Yes, switch to Form view before saving the form. If you don't, Microsoft Access clips the form on the right and bottom edges the next time you open the form.
>

Thanks again and have a great day/weekend,
Joe