Setting form dimensions

T

Tony

Hello

I wish to set the dimensions of some of my forms to around 12cm by 8cm on my
screen in Access 2007. There is an option in the properties to set the
height but not the width.

However when I go back into form view it takes up most of the screen. Far,
far bigger than I want.

Please help
Tony
 
J

Jerry Whittle

On the On Open event of the form, use the DoCmd.MoveSize Method. With it you
can precisely fix the height, width, and location of the form on the screen.

Check out MoveSize in VBA Help for more info.
 
J

Jerry Whittle

The Student Edition of Office 2007 does not come with Access. Are we talking
Access or Excel here?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Size 4
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1
How Can You Force a Particular Popup Form Height and Width? 4
Spliting dimensions down 3
Form Dimensions for different screens? 3
Main screen form area dimensions 2
PPT2000 Print dimensions problem 2
Dell 2007fp dimensions required. 2

Top