Size form content

[Guest]

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?

 

[Guest]

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

 

[OldPro]

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?

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.

 

[Guest]

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

 

[OldPro]

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

--
How1






- 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.