On an Event Scroll to Top of Form - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

On an Event Scroll to Top of Form

David Torrey de Frescheville

14 months ago

Is there any code that scrolls to the top of a form on an event? I have a tab order on a form with three columns. When I am at the bottom of one column on a control and the next tab stop is a control at the top of the next column, the focus goes directly to that control, but it’s below the top of the form. I then have to scroll up to see the top of the form. It’s just awkward and while I want the focus to stay in where I tabbed to, I’d prefer to have the form completely scroll to the top, while maintaining the focus on the control I intended. I’ve googled quite a bit but can’t seem to find any code that works. Thank you!

	Thomas Gonder @Reply 14 months ago
@David, I spent three days getting this issue solved in my ADS. It seems a lot of the information you'll find in ChatGPT and general forums on Access are just plain wrong. The code is a bit complicated to post here. What I have so far works, but it'll be a while before I can fully test it.

	Thomas Gonder @Reply 14 months ago
I should add, for those that may try SendKeys "{PGUP}" and the like, don't do it! You will find your forms jumping to another record when you least expect it. You'll need to use a Windows API.

	David Torrey de Frescheville OP @Reply 14 months ago
Hi Thomas - Thanks for responding. Yeah, I have found Chat GPT is terrible for figuring out VBA code. How did you solve this?

Thomas Gonder @Reply

14 months ago

@David I just finished a video explaining how I did scroll bar control with the ADS.
I can't give a link, because if I redo the video later, YouTube will give it a new link (Richard only allows links that don't disappear),
but look here: http://www.youtube.com/@adbs_ads
Look for the playlists (on left), then playlist 3000, View full playlist, and then video 3418.

See if it's what you want. Specifically to your question, see if what you see at 8:19 does the trick.
After a like and comment ;), you can contact me for a module that has the subroutine.

	David Torrey de Frescheville OP @Reply 14 months ago
Thank you!

	Thomas Gonder @Reply 14 months ago
Here is a link to a give away video I just made on the topic: https://youtu.be/Nouu-ALfcTQ From there you can request the sample .accdb file.

	David Torrey de Frescheville OP @Reply 14 months ago
Awesome. Thank you

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View