Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Size form content

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
How1 - 13 Jul 2007 09:06 GMT
I have distributed the front-end of the database. However when one of the
users opens the forms, the contents of the form do not fit the screen. How to
I reduce the content size in a form?
Signature

How1

SteveM - 13 Jul 2007 12:38 GMT
You could try using DoCmd.Maximize in the Open event of the form. That will
maximize the form to the current screen resolution. If you do this, you may
want to use DoCmd.Restore in the form's Close event.

Steve

> I have distributed the front-end of the database. However when one of the
> users opens the forms, the contents of the form do not fit the screen. How to
> I reduce the content size in a form?
OldPro - 13 Jul 2007 14:29 GMT
> I have distributed the front-end of the database. However when one of the
> users opens the forms, the contents of the form do not fit the screen. How to
> I reduce the content size in a form?
> --
> How1

1) Reset your screen size to the lowest possible screen size (probably
800x600) and determine the proper .top and .left and .height
and .width properties for each control for this screen size.
2)   Call a function from your form_load event that will test the
screen size and resize the form controls accordingly.
3) Use InsideHeight to determine what size screen the user is using.
How1 - 17 Jul 2007 09:46 GMT
Thanks for that.

Can the screen size me adjusted in access only? If so can you advise how to
adjust screen size in acccess and provide me with code that will allow me to
test the screen size and resize the form controls.

Regards

Signature

How1

> > I have distributed the front-end of the database. However when one of the
> > users opens the forms, the contents of the form do not fit the screen. How to
[quoted text clipped - 8 lines]
> screen size and resize the form controls accordingly.
> 3) Use InsideHeight to determine what size screen the user is using.
OldPro - 17 Jul 2007 15:05 GMT
> Thanks for that.
>
[quoted text clipped - 21 lines]
>
> - Show quoted text -

No, you can't change the screen size for Access alone, this is a
Windows function.  It isn't hard to switch the screensize in Windows
and switch it back when you are done.  Right-click on the desktop,
select Properties, and then Settings.
As far as the code goes, you will have to take ownership and write it
yourself.  In my experience code rarely works until you understand how
it works.  A single spelling error in 1000 lines of code could
invalidate the whole thing.  If you didn't write it, how would you
find the one spelling error, or even know if there was one?  If you
don't know what every character is supposed to do, how can you rewrite
it to work with your system?  Buy a book, learn the basic syntax,
study the help files, search this newsgroup for examples of each
function, start with something simple and build from there.  If you
have specific questions (that you have already tried to satisfy
through normal channels), then ask away. We like to encourage the next
generation of programmers.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.