There are VBA routines and utilities you can acquire that will dynamically
resize forms.  However; they are a lot better at making forms larger than
their original size than they are at making them smaller.  Much depends on
the objects in your forms.  Subforms and TabControls for instance usually
get buggered up.  It also gets dicey when various font size settings are
involved.

Most developers with this issue just design for the lowest setting that they
want to support.  I have maximum form dimensions that I know still fit on an
800 by 600 display and I just don't design forms any larger than that and
yes it often does feel like your developing with one hand tied behind your
back.

Access 2002 Desktop Developer's Handbook (Getz, Litwin)
There are 3 classes to handle screen resolution in the book.
They are worth the price of the book alone.
Plus you get the book!

There is a free utility here:
http://www.developershandbook.com/
This is the site for the Developer's Handbook that Joe mentioned.  I have
used the utility, with decent results.  Laptops with 1024 x 768 resolution
unfortunately sometimes do not display well at 800 x 600, making it difficult
to use the larger resolution for very long.  To get around this I have noted
the size of the largest rectangle that will fit on an 800 x 600 screen.  I
just temporarily add that rectangle on a 1024 x 768 screen and keep the
design within its boundaries.  I agree that it is rather a pain, but such
measures are the only choice.