Access 97 form sizes

[DeanL]

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]

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

[Tim Marshall]

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

[DeanL]

That's great guys, thanks for the help. Much appreciated...D...