The setting is under:
Office Button | Access Options | Current Database
It's called Document Window Options.
You have the choice of:
- Overlapping Windows (same as previous versions), or
- Tabbed Documents (the default in the new version.)
More info on adapting to the new version:
http://allenbrowne.com/Access2007.html

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
> When I try to design a new form in A2007 it is always maximized and the
> Min/Max buttons do not show despite the appropriate property settings.
[quoted text clipped - 11 lines]
>
> Rod
Rod Plastow - 21 Dec 2007 05:25 GMT
Hi Allen,
G'day to you. Thanks, that's fixed it and to think I scanned all the
options before I wrote the post. I missed that one, I was paying particular
attention to the Object Design options rather than Current Database. Why
does MS make the Tabbed Documents the default? Why is there no hint in the
Help about this? Here for example is an extract from A2007 help for Min/Max:
"Even when the MinMaxButtons property is set to None, a form always has
Maximize and Minimize buttons in Design view." No it b____y doesn't!!!
No, don't answer this. :-)
Merry Christmas to you.
Rod