scroll to top of form with VBA

  • Thread starter Thread starter mcnews
  • Start date Start date
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
 
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
 
Back
Top