How do I get consistent form size? I have all my forms defined as the same width and heighth, but when they are maximized, they exceed their defined size. I would like to have a consistent size that always comes up when the user enters the system and then allow the user to minimize it and then return to the original size.

My forms are all defined as 6.5" wide by 5" in heighth (the 6.5" nicely fits on the printed page). However, when the user maximizes the screen, there is some blank space on the right. What I would really like to do is define the screen as 6.5" by 7" (or whatever vertically would fit on the screen), but I haven't figured out how to get around the other stuff on my access screen (e.g., the tool bars and the access logo at the top).

Any suggestions? I know this is rather nebulous, but I don't know how else to ask.

Thanks.

Geo.T.

Check out this link:
http://www.mvps.org/access/forms/frm0042.htm
hth.

Ignoring form size for a second. You're worrying about your forms fitting on a printed page when forms should not be printed, that is what reports are for. Forms are just for viewing the info on the screen, reports are for paper and other paper like methods like pdf or snapshot.

HTH
Ken

Ken,

Thanks for your input, but it does ignore my queston. I somehow think what I need to do is size the window to fit the form or something like that. What I'm looking for is consistency for my users with all my forms having the same appearance and standard command buttons in the same position on each form etc.

Thanks.

Geo.T.

My main point was to ingore your question and hopefully get you on the better path for printing. If you still want the same form sizes throughout your db then Insidewidth and insideheight might be 2 useful properties for you. You should be able to use those in the on open event of the form. You should need no code for appearance and command buttons. That could simply be a template form if you need a lot of forms or just following your standard design.

HTH
Ken

Thanks for your help. I looked for InsideWidth and InsideHeight in the Microsoft help site and found a routine for setting these two parameters to the window size. However, the subroutine wants the form as a parameter (frm As Form) and I can't seem to pass it what it wants. I've tried "Me.Form" and "Me.FormName" and just "Me" (without the quotes, of course), but kept getting some sort of error indicating that I wasn't passing the right thing.

Within a module can I set parameters for my form (e.g., InsideWidth and InsideHeight)? And if so, how do I pass the form to the subroutine or reference the form from the subroutine?

I'm trying not to be too obtuse, but I'm new to Access and VBA and haven't really absorbed the paradigm just yet.

Thanks.

Geo.T.

Me should be fine if it wants "frm as form", I use that all the time.

You could just set these yourself in the on open event of the form. Assuming you want all forms the same you could have 2 global variables.

glngHeight and glngWidth

Now the on open code

me.insideheight=glngheight
me.insidewidth=glngwidth

HTH
Ken

Yes.

Thanks again.

Geo.T.

You're welcome, glad to help.