Form Size

[Tony]

Hello
I am trying to set up a database for a drug and alcohol
I have done the tables: client and probs
I have done one form for the client but it is the width of the screen.

In design view the form width is 12.998cm and the section view height is
3.499cm.
These are dimensions that I like but it does not display this size in form
view.
Form view takes up the width of the screen.

Can someone help?
Thanks
Tony

 

[Jeanette Cunningham]

Hi Tony,
2 things to watch out for.
If using A2007, check the forms's Fit To Screen property and set it to No.

For A2007, A2003 and older.
The form may be opening maximized.
You can put this code on the form's Activate event.

Private Sub Form_Activate()
DoCmd.Restore
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tony]

Thanks Jeanette and hello from Darwin
I am using A2007
The form Fit To Screen property was already set to No.
I put you code in and took it out again with no difference to the form size
I guess I need to use some sort of resize command

 

[Jeanette Cunningham]

The other A2007 feature to watch is for the access options.

Click the big office button in top RH corner.
Choose Access options | Current Database
Find Document Window Options and choose Overlapping Windows.

Thanks for sharing that you are from Darwin.
We get a few aussie people asking questions on these access discussion
groups.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tony]

Voila !
It is just starting to look beautiful!
Thanks a lot for helping me out of my despair.
I'll have a beer, not like a Luddite but, like a Darwinite.

Thanks Jeanette