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

Welcome Guest ( Log In | 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

UtterAccess Member
Posts: 49



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: 57,241
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

UtterAccess Member
Posts: 49



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: 57,241
From: SoCal, USA



You're welcome. Good luck with your project.


--------------------
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 26th July 2014 - 08:09 AM