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 / General 1 / February 2006

Tip: Looking for answers? Try searching our database.

Access 97 form sizes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DeanL - 15 Feb 2006 00:33 GMT
Hi all,

I've been developing an Access 97 DB on my WinXP Pro machine and have
sized all forms, reports, etc. to work on a 1024 x 768 resolution
screen.  The problem I have is that when on of my Windows 2000 (SP4)
users runs the DB in 1024 x 768 screen res then the forms disappear off
the side of the screen as if it's being viewed in 800 x 600.  I've
double checked the screen res and it seems to have no problems running
on XP but in some cases, even the fonts appear outrageously large.
I've also checked th fonts and every one I've used in my DB is present
on the Windows 2000 machines in the correct sizes.

I'm at a bit of a loss so if anyone can help I'd be very appreciative.

Many thanks, D...
Rick Brandt - 15 Feb 2006 00:38 GMT
> Hi all,
>
[quoted text clipped - 11 lines]
>
> Many thanks, D...

Sounds like they have Windows set to large fonts.  That will make the form
larger.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Tim Marshall - 15 Feb 2006 01:37 GMT
>>I've also checked th fonts and every one I've used in my DB is present
>>on the Windows 2000 machines in the correct sizes.
>>
>>I'm at a bit of a loss so if anyone can help I'd be very appreciative.

> Sounds like they have Windows set to large fonts.  That will make the form
> larger.

If that's the case, I'd recommend a splash or opening form that runs a
couple of procedures to check resolution size and font size and let the
user know if the user's system doesn't meet your design requirements.
I've been doing this for time immemorial with a label or disabled &
locked text box that says:

"This application has been designed for a minimum screen resolution of
1024 by 658 [or 800 by 600 or whatever] and small fonts"

and then a disabled & locked  text box which tells the user what res and
font size they are set to.  If minimum requirements are not met, then
"Warning! - " and " - You may have difficulty with some screen displays"
prefixed and suffixed and perhaps the fore colour turned red.

There's code on the Access Web by Dev Ashish for screen resolution and
while there may be something there too for font size, I started using a
while ago code from Randy Birch's VB net pages.  I don't have the URLs
handy right now and am on very slow dial up at home so if you can't find
these, drop a note here tomorrow and I'll look for em at work.

Signature

Tim   http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

DeanL - 15 Feb 2006 04:43 GMT
That's great guys, thanks for the help.  Much appreciated...D...
 
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.