A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How size the window a form appears in ???



 
 
Thread Tools Display Modes
  #1  
Old May 10th, 2004, 11:56 PM
Ryan
external usenet poster
 
Posts: n/a
Default How size the window a form appears in ???

I have designed many forms, they are continuous forms , mostly about 6ins wide.
When my VBA code opens each form, it appears in a window about 3x3 ins. The right side of the form is cut off and I see only one record in my continuous form instead of several. How do I get the windows to open at a pre-determined size??? I have tried resizing the window but the next time it opens, it reverts back to 3x3ins. This is absorbing a lot my development time. Thanks. Ryan.
  #2  
Old May 11th, 2004, 09:45 AM
Jesper F
external usenet poster
 
Posts: n/a
Default How size the window a form appears in ???

How do I get the windows to open at a pre-determined
size???

Do you have the"auto-resize" property of the form set
to "yes"?

  #3  
Old May 11th, 2004, 04:41 PM
david
external usenet poster
 
Posts: n/a
Default How size the window a form appears in ???

Its set to NO and thats how it must remain.
  #4  
Old May 11th, 2004, 08:06 PM
Crystal
external usenet poster
 
Posts: n/a
Default How size the window a form appears in ???

You have a couple of options to try depending on what you really want.

You can make the form maximized (but this will maximize all forms) by opening the form properties and clicking the ellipsis next to the "on open" line of the "event" tab, selecting "macro builder" and in the macro builder type "maximize" in the action box and save it. Then, when you open the form it will open full screen.

or

If you only want that one form a different size (not maximized) you can resize the form in form view (not design view) and click save. Then close the database and open the database again. The form should have saved the size.

Hope this helps.
Crystal
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.