Use command button to jump down on a long form

SteveL13
SteveL13 used Ask the Experts™
on
I have a very long horizontal form.  When I click a command button on the form I want the focus of the form to jump down to a designated spot on the form.  Can this be done?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
do you mean "long vertical form"?

Author

Commented:
Yes.  Sorry.
Distinguished Expert 2017
Commented:
Have you considered making forms that fit the screen and which don't require scrolling?    A common solution is to use tabs.  You can group data so that each tab shows data that belongs together.  Of course, there may also be a schema design issue at play here.
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
You can insert page breaks - see the attached demo, please.
PageBreak.accdb

Author

Commented:
Decided to use tabs but the furnished file was extremely helpful  I'm sure I'll use the concept some day.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial