size to fit form command

[Stephen Ernst]

I can't find the "Size To Fit Form" command in Access 2007. It should be one
of the Windows commands but I don't have a Windows menu item in the ribbon or
on the menu bar.

 

[Maurice]

Stephen,

In a regular db with no alterations it should be under the [Home]-tab
previous to the [Find]-tab. If it isn't there are you sure the Ribbon isn't
altered?

hth

 

[Stephen Ernst]

Maurice,

I haven't altered the ribbon in this db that I just created yesterday. It
only has 2 forms in it so far. My ribbon goes from Sort & Filter to Find with
no intervening Windows tab. I've just looked at a few of my other dbs and
notice that the Windows tab is where it belongs so my question has now
transformed to where did the Windows tab of the ribbon go and how do I get it
back?

Stephen,

In a regular db with no alterations it should be under the [Home]-tab
previous to the [Find]-tab. If it isn't there are you sure the Ribbon isn't
altered?

hth
--
Maurice Ausum

I can't find the "Size To Fit Form" command in Access 2007. It should be one
of the Windows commands but I don't have a Windows menu item in the ribbon or
on the menu bar.

 

[Maurice]

Hi Stephen,

In that case it might be that you have the current db set to "tabbed"
windows. In that case you won't see the size to fit form becuse you'll see a
tabbed window.
You can change the setting under Office button-> Access options -> current
database -> Document window options -> change to overlapping windows. This
should bring up the size to fit form button on the ribbon.

hth
--
Maurice Ausum

Maurice,

I haven't altered the ribbon in this db that I just created yesterday. It
only has 2 forms in it so far. My ribbon goes from Sort & Filter to Find with
no intervening Windows tab. I've just looked at a few of my other dbs and
notice that the Windows tab is where it belongs so my question has now
transformed to where did the Windows tab of the ribbon go and how do I get it
back?

Stephen,

In a regular db with no alterations it should be under the [Home]-tab
previous to the [Find]-tab. If it isn't there are you sure the Ribbon isn't
altered?

hth
--
Maurice Ausum

I can't find the "Size To Fit Form" command in Access 2007. It should be one
of the Windows commands but I don't have a Windows menu item in the ribbon or
on the menu bar.

 

[Stephen Ernst]

Thanks, Maurice. That did the trick. I might say it's a bit obscure for a
default setting that is that crippling to be buried where it is but now that
I know...

Steve

Hi Stephen,

In that case it might be that you have the current db set to "tabbed"
windows. In that case you won't see the size to fit form becuse you'll see a
tabbed window.
You can change the setting under Office button-> Access options -> current
database -> Document window options -> change to overlapping windows. This
should bring up the size to fit form button on the ribbon.

hth
--
Maurice Ausum

Maurice,

I haven't altered the ribbon in this db that I just created yesterday. It
only has 2 forms in it so far. My ribbon goes from Sort & Filter to Find with
no intervening Windows tab. I've just looked at a few of my other dbs and
notice that the Windows tab is where it belongs so my question has now
transformed to where did the Windows tab of the ribbon go and how do I get it
back?

Stephen,

In a regular db with no alterations it should be under the [Home]-tab
previous to the [Find]-tab. If it isn't there are you sure the Ribbon isn't
altered?

hth
--
Maurice Ausum


:

I can't find the "Size To Fit Form" command in Access 2007. It should be one
of the Windows commands but I don't have a Windows menu item in the ribbon or
on the menu bar.