UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> VBA to scroll to left of form    
 
   
Parrot_Head
post Aug 5 2009, 03:38 PM
Post#1



Posts: 49
Joined: 31-October 07



I have a continuous form which scrolls horizontally. The first two controls (text boxes) on the form contain default values and the tab stops are turned off or the text box in disabled and locked. As the last field on the form loses focus, the form does scroll back to the left, but only to the third control. Is there any way to have the form scroll all the way to the left after the last test box loses focus but still give the focus to the first control in the tab order?
Thanks in advance.
Go to the top of the page
 
theDBguy
post Aug 5 2009, 03:43 PM
Post#2


Access Wiki and Forums Moderator
Posts: 62,157
Joined: 19-June 07
From: SoCal, USA


Hi,
If I understand you correctly, you can try something like this:
1. Create an unbound textbox on your form with a height and width set to 0"
2. Delete the label for this textbox and place it in the upper left corner of your form.
3. Make sure that this textbox is first in the Tab Order
4. In the GotFocus event of this textbox, you can execute code to move the focus to the next control
(Just an idea)
Hope that helps...
Go to the top of the page
 
Parrot_Head
post Aug 5 2009, 04:00 PM
Post#3



Posts: 49
Joined: 31-October 07



Got it thanks...I figured it had to be something along those lines.
Go to the top of the page
 
theDBguy
post Aug 5 2009, 04:31 PM
Post#4


Access Wiki and Forums Moderator
Posts: 62,157
Joined: 19-June 07
From: SoCal, USA


You're welcome. Good luck with your project.
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    27th May 2015 - 12:45 PM