For reports, you can use the "can grow" and "can shrink" options to have
text boxes expand as necessary (don't forget to set these options for the
section as well). The controls on forms are fixed and will not shrink and
grow unless you write code to open the form in design view on the fly and
change the properties of the controls - this is not for the faint of heart
and may cause problems if you share a front end database.
For forms, make the controls as wide and tall as you have room for. If the
user cannot see all the data in a control, they can move the pointer to the
control and press shift-f2 to bring up the zoombox. If you prefer, you can
open the zoombox on the double-click event or even open your own zoom form
if you don't like the way the built-in zoom works.
