If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Size
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 |
#2
|
|||
|
|||
Form Size
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" wrote in message ... 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 |
#3
|
|||
|
|||
Form Size
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" wrote in message ... 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" wrote in message ... 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 |
#4
|
|||
|
|||
Form Size
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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
#5
|
|||
|
|||
Form Size
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 "Jeanette Cunningham" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|