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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Universal Form Size?



 
 
Thread Tools Display Modes
  #1  
Old October 2nd, 2006, 03:15 PM posted to microsoft.public.access.forms
Access Africa
external usenet poster
 
Posts: 13
Default Universal Form Size?

I have a problem that all my users have different screen resolutions which
ultimately affects my forms. Is there anyway that I can set something so that
all the forms will look the same no matter what your screens resolution?

  #2  
Old October 2nd, 2006, 03:34 PM posted to microsoft.public.access.forms
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default Universal Form Size?

Not as a property.

You can put in code to detect the user's resolution and resize your form
accordingly, but it's not trivial code. They show you how to do this in the
Developer's Handbook (from Sybex: see http://www.developershandbook.com/ for
details). You can download an MDE veresion of the code from
http://www.developershandbook.com/downloads.htm and use it in your
application.

Another option is to purchase ShrinkerStretcher from Peter's Software
http://www.peterssoftware.com/ss.htm


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Access Africa" wrote in message
...
I have a problem that all my users have different screen resolutions which
ultimately affects my forms. Is there anyway that I can set something so
that
all the forms will look the same no matter what your screens resolution?



  #3  
Old October 2nd, 2006, 03:40 PM posted to microsoft.public.access.forms
Al Campagna
external usenet poster
 
Posts: 421
Default Universal Form Size?

Access Africa,
Try doing a Google groups search on "public.access" "forms" "resizing". There are many
solutions and comments regarding this function.
Be aware that resizing is basically a mathematical process, and may not display a
"precise" scaled report.

Also, when developing for multiple resolutions it might be easiest to design in
800x600. It may appear smaller at higher resolutions, but will always work without hiding
any controls.

I think the most popular resizers are...
http://www.developershandbook.com/
(Consider investing in "The Developer's Handbook" for your version of
Access. It has the source code for the resizing function.)

http://www.peterssoftware.com/ss.htm


http://www.jamiessoftware.tk


--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Access Africa" wrote in message
...
I have a problem that all my users have different screen resolutions which
ultimately affects my forms. Is there anyway that I can set something so that
all the forms will look the same no matter what your screens resolution?



 




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 09:54 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.