scroll to top of form with VBA

M

mcnews

i don't want to see the entire form when i use it as a subform.
how can i either force it to scroll to the top left or prevent it from
being moved?

tia.
mcnewsxp
 
L

Larry Daugherty

In the Database | Forms window, copy and paste the (sub)form with a
new name for backup purposes. Open the original copy of the form in
design view. Turn off Header and Footer. Shrink the Detail section
down to not much more than the size of the controls on the form. Set
the view to Continuous Forms. Save the newly designed form. Open the
main form.

You may have to repeat the above design process a few times to get
what you want.

HTH
 
Top