How can I prevent my Access form from scrolling...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

When I tab to a subform, the entire screen moves down and hides the top of
the form...what do I need to do to prevent this from happening?

I appreciate your help,
petra
 
In the On Enter event of your main form use:

DoCmd Maximize


This will enlarge your form to take up the whole screen
and therefore tabbing to a subform with it won't move the
rest of the screen.
 
I think when the Subform gets the Focus, Access will try
to make the whole Subform visible. Hence, the you get the
effect.

Design your main Form (including the Subform) so that it
fits on the (maximized) screen. Most users hate Forms
that move up & down so avoid creating Forms that the
screen cannot display in full.

If you are short of space on the Form, consider using the
TabControl on the Form. See Access Help on TabControl.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top