Form display not correct in 2010

[Gkirkup]

I am converting a big application from 2003 .mdb to 2010 .accdb. The forms all display the full size of the screen, and have only an 'X' in the top right corner, not the three buttons to minimize etc.
The forms display the correct size in design view. The format settings appear to be correct.
How can I fix this and make the forms display the correct size?

Robert

 

[boblarson]

You need to change from Tabbed Document format to Overlapping Window format.

See here for how:
http://www.btabdevelopment.com/ts/2010tabbed

 

[Gkirkup]

Bob: Thanks! That worked fine.
Is there any way that I can remove the ribbon from users' copies of the database? The options along the top, that program users don't need?

Robert

 

[boblarson]

You can create a blank Ribbon. My XML to do this is:

<customUI xmlns="[URL]http://schemas.microsoft.com/office/2006/01/customui[/URL]">
<ribbon startFromScratch="true">
</ribbon>
</customUI>

You need to create a table named USysRibbons which has two fields

RibbonName (Text)
RibbonXML (Memo)

 

[Gkirkup]

Bob: Thanks. So there is no setting to just turn the ribbon off and on?

Robert

 

[boblarson]

Bob: Thanks. So there is no setting to just turn the ribbon off and on?

Robert

Nope, sorry.