how do i get access 2010 form objects to center on the screen?

[rebfein]

AT LAST... the database is done!

However, my boss would like it better if all the objects (i.e. buttons, fields labels, etc.) could center on the screen as they are opened; instead of just on the left side.

Here's the design view, where the header label and line are set to stretch across the top.


And the actual form.




Any assistance would be appreciated.

Thank you,

Rebecca Feinstein

[ssanfu]

AT LAST... the database is done!

You're joking.... Right??? You KNOW that someone will say "Boy, it sure would be nice if we could just ........." or "Can we add .....".


It took me a minute to understand what you were asking.

I never liked or used the the "Tabbed View" forms.
On a COPY of your dB, try this..

Open the dB
Go to "Files - Options - Current database"
Look for "Document Window Options".
Click the "Overlapping Windows" option.
Click OK (bottom right).
This a "system" setting



Now do this for EACH and EVERY one of your forms.

Open the form in design view.
Open the form properties dialog box.
Click on the "Format" tab.
Look for "Auto Center". Set it to "YES".
Look for "Auto Resize". Set it to "NO"
Save the form.
You might have to resize each form to the size/location you want. Whatever size you make the form is the size it will always open to.

Warning: you might have to do more coding to control the display of forms left open or not hidden, if the last form opened is smaller than any previous forms.

[CJ_London]

usual case of mission creep.

But then the boss is paying the bill

seriously before you take on ssanfu's suggestion, do clarify with the boss what he/she means - clarify that he/she is happy having smaller forms that can be moved round the screen. clarify that he is happy to have one form overlay another. in other words clarify exactly what he/she expects - just this form? all forms? what about different screen sizes/resolutions? Just a shame it wasn't specified from the get go.

[orange]

Good points Steve!.

I thought, finally, I've found one!!

AT LAST... the database is done!

But I shook my head and reality set in....we're still looking for a finalized, final version.

Nothing like detailed specs-- in writing.

Oh wait, we'll consider that for the next version-- just sign here and Date it.

[rebfein]

Thank you for the quick response, I'll give it a try.

...I wonder what Julius Caesar would think about your take on his "Veni ,Vidi ,Vici" quote (which I love).

[CJ_London]

if you want to place controls centrally on a form I don't think there is any access setting you can use, you'll need to work it out for each control and put some code in the form resize event

to centre a control on the form

mycontrol.left=(insidewidth-mycontrol.width)/2
mycontrol.top=(insideheight-mycontrol.height)/2

to centre around the left side of a vertical centre

mycontrol.left=(=(insidewidth-mycontrol.width)/2-mycontrol.width-somevalue 'somevalue is the number of twips (1440 twips=1 inch) you want as a space between mycontrol's right edge and the centre. modify for controls to appear on the right side of centre

should give you the idea.

[rebfein]

And in reply to the "you're joking..." remark. Of course I'm joking!

I'm a technical writer by trade. And believe you me, I KNOW that the finished product of anything is NEVER what was envisioned, written or produced in the planning stages.

[ItsMe]

Just as a thought, you can build different FE files for different monitor sizes and aspect ratios (or buy everyone the same sized monitors). If aesthetics matter, you might find this a better option than building an HTML5 web app with CSS and media queries.

[rebfein]

Thank you all for your help.

It turns out, that my boss decided, that we can do the form centering thing on the next version of the db.

So, I'm marking this thread solved and, Yes, he does sign off on my timecards!