Guidance for forms in Access 2007

[gary b]

I am familiar with Access 2000/2003. In those versions, a form could
be sized (e.g., 2" by 2") and centered on the screen. The form had
borders dictated by the Borders property: dialog, sizable, etc. Alas,
I have been forced to use Access 2007.

In Access 2007, I cannot get a form 'centered' in the 'design (tab)
page'. The form, whether in Design or View mode, is anchored to the
top left corner of the tab page or the the view screen. The left side
of the form is anchored to the right side of the Navigation section. I
can detect no borders in View mode...

It appears I am missing something *very* fundamental in Access 2007
and how forms are used/displayed. Is my inability to size or position
forms due to the fact that my database was created in Access 2000 and
'ported over' into Access 2007?

One last attempt to describe my problem (and my frustration!): In
Access 2000, I could have a form open upon starting Access. That form
could be centered on the screen and then maximized to occupy the
entire screen if I wanted to. I *can* specify which form to open when
Access starts (Access options)... but I cannot perform *any* form
management as far as size, screen position, visible border, and so on.

Are any tutorials available to teach this old dog new tricks?

gary b

 

[Mark Andrews]

Try
- Office Button (top left corner)
- Access Options
- Current database
- Document Window Options (set to Overlapping windows)

That will force it back to closer to the Access2003 look and feel.

HTH,
Mark Andrews
RPT Software
http://www.rptsoftware.com

PS: The more you use Access2007 the more you will like it better. Make sure
you get SP2!!!!!!!!!!!!

 

[gary b]

Try
- Office Button (top left corner)
- Access Options
- Current database
- Document Window Options (set to Overlapping windows)

That will force it back to closer to the Access2003 look and feel.

HTH,
Mark Andrews
RPT Softwarehttp://www.rptsoftware.com

PS: The more you use Access2007 the more you will like it better.  Makesure
you get SP2!!!!!!!!!!!!

Thanks, Mark!

I will verify that I have SP2 and will reconfigure to Overlapping
Windows.

In my frustration, I have been playing with some of my existing forms.
I have been able to 'unlock' them... I can move them around the
screen. I've not yet been successful with 'centering' form on Open --
even though AutoCenter = True. But will keep playing.

Thanks for your input and your time, sir.

gary b

 

[gary b]

Whoa!!! Now THAT'S what I'm talkin' about!

That is much closer to what I am used to. Thanks a bunch, Mark!!

gb

 

[Mark Andrews]

If all else fails you can always use code to position and size the window
exactly how you want:
example:
Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize 0.7 *1440, 0.7* 1440, 8 * 1440, 6 * 1440

End Sub


Whoa!!! Now THAT'S what I'm talkin' about!

That is much closer to what I am used to. Thanks a bunch, Mark!!

gb