Formatting Forms (2 Qs)

[accessnewbie352]

Q1) How do I change the view size of a form? When I click to open it, it opens without scrollbars or an option for me to maximize/minimize.
Q2) How do I change the print properties of a form? I have a form that is printing out in 2 pages but i would like to print in 1 page. I know I can make a report but would like to print the form.

[Rawb]

Q1) If you want to be able to resize the Form whenever you want, just make sure the Border Size Property of the Form is set to "Sizeable". If you are wanting to permanently change the size, then just resize the Form in Design Mode before saving it - the next time it opens, it will be the new size.

Q2) Forms are designed for display on a computer screen, not to be printed. In all cases, you're far better off creating a Report for printed material.

[Missinglinq]

As to Q1: Many things work differently in post-2003 Databases because of the Document Window Options, a new option with 2007/2010, which defaults to 'Tabbed Documents.' Changing this option to Overlapping Windows basically causes many things in Form Design to act like they did pre-2007.

1. Click on FILE in the menu (top left)
2. Click on OPTIONS (just above EXIT)
3. Click on Current Database in left hand pane
4. Under Applications Options, look for Document Window Options, tick Overlapping Windows
5. Click on OK (Bottom, Right)
6. Close the Message box, then Close and Re-open Access

Q2: You not only can...you should use a Report! If you're going to insist on using an object for something that it is not designed for, you're pretty much stuck with what you have. There are no 'print properties' of Forms, to my knowledge; I think you'd simply have to change the size of the Form, itself.

Linq ;0)>