By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,484 Members | 1,792 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,484 IT Pros & Developers. It's quick & easy.

Access 97 form sizes

P: n/a
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...

Feb 15 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
DeanL wrote:
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...


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

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 15 '06 #2

P: n/a
Rick Brandt wrote:
DeanL wrote:
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.

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

P: n/a
That's great guys, thanks for the help. Much appreciated...D...

Feb 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.