Access 2007 Idiot Question - Resizing forms (1 Viewer)

XLEAccessGuru · Jul 10, 2008

OK. I'm totally embarrassed to be asking this b/c I'm quite an advanced Access developer, but 2007 has me stumped on something really simple. I'm developing my first db in 07 and have tried everything from help searches to msdn to googling.

How the HECK do I resize a form window in 2007 and get it to open in non-maximized mode? When I open in form view they automatically maximize and I can't seem to restore the form window so that I can rezise and/or move it?

rainman89 · Jul 10, 2008

Dont feel bad... I gave up on 2007 and went back to 2003!!!

only thing i can think of is you have overlapping windows instead of the tabbed view?

XLEAccessGuru · Jul 10, 2008

Got it.

Nevermind. I figured it out finally. For anyone wondering, it's in Access Options..., Current Database, Document Window Options. Select Overlapping Windows

rainman89 · Jul 10, 2008

ah so i was right... good to know!

pam0566 · Aug 14, 2008

I also had this problem, its fixed now for themost part, but sometimes, [expecially with my switchboard] after i open another form, the switchboard reopens FULL size, not smaller... any ideas how to fix this?

dkinley · Aug 14, 2008

I think that is DoCmd.Restore, you can get around this by ensuring your form properties are set correctly - Auto Resize and/or Fit to Screen.

-dK

pam0566 · Aug 14, 2008

i already ck'd that, and even if autosize is no and fit to screen is no, a few of my forms open up maximized.

pam0566 · Aug 14, 2008

I changed autosize to yes, fit to screen no, and when i click on it it still opens up full screen.

efatima · Oct 31, 2009

Re: Got it.

oh thanks it is great.............
i am glad for this

dcb · Oct 31, 2009

I have had this problem with one of my DB's that I upgraded to ACCCDB
All the pop up's etc opened at full screen & when I turned tabs off I kept getting errors

I have now resorted to a Sub that does the DoCmd.Restore and MoveSize events to correct.... I am hoping that someone finds a better way!

christakis · Nov 2, 2009

I have a similar question. When I open a form it is in window mode and exactly as I want it to be. How can I make it to auto-resize, when I press the maximise button? I want all fields in the red box to stay put and the rest (tab and subform) to auto-resize. Please see attached images for more info.

Cheers,
Christakis

christakis · Nov 3, 2009

Not possible then?

arifmasum · Mar 15, 2012

i was also facing this problem.. got the answer here... thanks

)

eneyardi · Oct 21, 2014

pam0566 said:
I changed autosize to yes, fit to screen no, and when i click on it it still opens up full screen.

go to properties click other>>Pop up>>select yes

eneyardi · Oct 21, 2014

XLEAccessGuru said:
OK. I'm totally embarrassed to be asking this b/c I'm quite an advanced Access developer, but 2007 has me stumped on something really simple. I'm developing my first db in 07 and have tried everything from help searches to msdn to googling.

How the HECK do I resize a form window in 2007 and get it to open in non-maximized mode? When I open in form view they automatically maximize and I can't seem to restore the form window so that I can rezise and/or move it?

just go to properties click other>>Pop up>>select yes

Access 2007 Idiot Question - Resizing forms (1 Viewer)

XLEAccessGuru

XLEGuru

rainman89

I cant find the any key..

XLEAccessGuru

XLEGuru

rainman89

I cant find the any key..

pam0566

Registered User.

dkinley

Access Hack by Choice

pam0566

Registered User.

pam0566

Registered User.

efatima

New member

dcb

Normally Lost

christakis

Registered User.

Attachments

christakis

Registered User.

arifmasum

Registered User.

eneyardi

New member

eneyardi

New member

Similar threads

Users who are viewing this thread