Form Size

[gsandy]

When I create a form in design view and then open it, the form fills the whole area. The Fit To Screen property is set to No, and Auto Resize makes no difference no matter what it is set at.
How can I reduce the form size (so it looks like an Excel form)?
Thanks Sandy

 

[pbaldy]

Check in File/Access Options/Current Database/Document Windows Options (differs by version)

You want Overlapping Windows.

 

[gsandy]

Thanks Paul, that worked. Cheers Sandy

 

[pbaldy]

Happy to help Sandy!

 

[gsandy]

It's probably a bit late, but in design mode I drag the right hand border in but it jumps back to its previous position! I cant even change the width property!The bottom border works fine.

 

[pbaldy]

I'd look for a control (textbox, line, whatever) that extends beyond where you're trying to drag to. Access won't let you drag the border if something is there.

 

[gsandy]

Got that one solved, the header box just needed dragging in.