Screen Resolution, Font Size and Forms

[CHTHOMAS]

Even after programmatically changing user's resolution to 800 x 600, if the user uses Large Font on an 800x600 resolution my forms won't fit appropriately. Any Codes to change the Screen Font from Large to Small? Any help or suggestions will be highly appreciated.<br>
Charley<br>
<A HREF="mailto:chthomas@tebodinme.co.ae">chthomas@tebodinme.co.ae</A>

 

[tanalee]

Aloha...<br>
<br>
I expect that you could code your form so that the font size is limited to whatever size you deem appropriate.<br>
<br>
However, I also expect that people who enlarge the font do so because they can't read the smaller font. If you freeze the form to small font, and the user cannot read it, what is the use of having the form at all?<br>
<br>
I just bought 'Access 97 Developer's Handbook: 3rd Ed'---Litwin, Getz, and Gilbert) yesterday. It contains some discussion on resizing forms according to the user's screen resolution ( 'Screen Resolutions and Distributing Forms', page 465ff), and handling fonts ( 'Font-Handling Functions', page 1160ff), but I haven't taken the opportunity to review the discussions yet.<br>
<br>
Can you get your hands on a copy of the book?<br>
<br>
Tana-Lee

 

[vbaprogammer]

There is a shareware utility out there somewhere which automatically resizes your forms to fit the screen.<br>
<br>
I will try to locate it for you, but you may be able to find it before I do.

 

[vbaprogammer]

http://www.peterssoftware.com<br>

<br>
This is one of perhaps many. I found this one first. (looks like it's a little bit more than shareware).