Is it possible to change resolution in a form?

hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

I doubt it, but even if it is, what a splendid way to hack your users off!

Keith.

If that's the situation, it's poorly designed... design for the lowest user
resolution try dividing the form into linked forms or a tabbed form. People
are bound to make mistakes or leave data out with too many fields.

"hanski" wrote:

hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

A question like this suggests that you should first examine the design of
your tables. It sounds like your tables are not normalized.

Steve



"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

The original post mentioned nothing about the way the form was "fed". On
what basis are you assuming this implies a problem with table normalization?
(not that I'd necessarily disagree, but curious how you arrived there...)

Jeff

"Steve" wrote in message
m...
A question like this suggests that you should first examine the design of
your tables. It sounds like your tables are not normalized.

Steve



"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

As suggested in a couple of the responses, stuffing more controls onto a
form doesn't make that form more usable.

There are ways to 'stack' (see tab controls) data without showing it all at
once.

And to follow up on Steve's implication, what is the source of the data
displayed in the form -- describe in some detail, with example data if you
wish more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

It sounds like the OP has an inordinate number of fields on his form. If it
takes a large number of fields to display some functionality of the
database, that's a red flag that there could be something wrong with the
design of the tables. I'm not saying there is; just saying the OP should
look there first instead of trying to put a bandaid on a problem.

Steve



"Jeff Boyce" wrote in message
...
The original post mentioned nothing about the way the form was "fed". On
what basis are you assuming this implies a problem with table
normalization? (not that I'd necessarily disagree, but curious how you
arrived there...)

Jeff

"Steve" wrote in message
m...
A question like this suggests that you should first examine the design of
your tables. It sounds like your tables are not normalized.

Steve



"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu

Thanks.

"Steve" wrote in message
m...
It sounds like the OP has an inordinate number of fields on his form. If
it takes a large number of fields to display some functionality of the
database, that's a red flag that there could be something wrong with the
design of the tables. I'm not saying there is; just saying the OP should
look there first instead of trying to put a bandaid on a problem.

Steve



"Jeff Boyce" wrote in message
...
The original post mentioned nothing about the way the form was "fed". On
what basis are you assuming this implies a problem with table
normalization? (not that I'd necessarily disagree, but curious how you
arrived there...)

Jeff

"Steve" wrote in message
m...
A question like this suggests that you should first examine the design of
your tables. It sounds like your tables are not normalized.

Steve



"hanski" wrote in message
...
hi.

I have one form which is full of everything, so I thought is is
possible via VBA, for instance, to change screen resolution higher?

t hannu