Assigning a "Return" function to command button

[Ed]

I have a form with tab controls. Each tab has a sub-form. I designed the form
and tabs to avoid scrolling. However, in one instance some minor scrolling
will be needed to return to the top of the main form - no way around it.

I was going to place a command button and assign an action/macro to it that
would return the user to the top of the main form (I want to remove the
vertical scroll bar). While the "return" command is referenced in text, for
the life of me I can't seem to figure out what action to assign the button so
that it will bring me to the top of the main form.

Any ideas would be appreciated.

Thanks

Ed

 

[John Spencer]

One method:
You could add a small transparent button (Transparent property set to Yes) at
the top of the form ( no actions assigned to any events).

Set this button to be the last item in the tab order.

Now when you tab out of the control on the bottom of the form the focus will
be set to the transparent button at the top of the screen.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Ed]

Thanks.

After thinking about it for awhile I opted to use a command button to which
I assigned a "goto" macro. The object it goes to is a "new record" command
button at the top of the main form - I just moved it closer to the top than
it normally would have been in order to achieve the desired effect. While it
places the focus on the new record button I don't think anyone will see that
or use it.

Thanks for the idea.

Ed