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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Subform - Scrolls To The Right Automatically, Access 2016    
 
   
hemant
post Mar 28 2020, 04:10 AM
Post#1



Posts: 81
Joined: 19-February 20
From: Mumbai, India


I have a SplitForm and two subforms on its detail section. The subform container width of both are smaller than the actual subforms. Hence, they have horizontal scroll bars.

Whenever the main Splitform moves to a record that has a record in the SubForm-A, the subform's horizontal scroll bar automatically moves to the right. But this does not happen with the other SubForm. Pls see the attached image of the subforms.

Why would this happen? How do I keep the hz scroll bar to the left?
This post has been edited by hemant: Mar 28 2020, 04:11 AM
Attached File(s)
Attached File  SubForm_Auto_scrolls_to_right.jpg ( 117.69K )Number of downloads: 3
 
Go to the top of the page
 
BentBrain
post Mar 28 2020, 05:16 AM
Post#2



Posts: 563
Joined: 10-February 03
From: Thailand


Hi Hemant
Are you setting focus on any field in the subform?

What is your tab order? is your first field on the subform able to be selected?

Regards
BB

--------------------
"There is no excellent beauty that hath not some strangeness in the proportion" Francis Bacon
Go to the top of the page
 
missinglinq
post Mar 28 2020, 06:07 AM
Post#3



Posts: 4,691
Joined: 11-November 02



As @BentBrain is suggesting...it sounds as if the first Control to get Focus, in the errant Subform, is a Control on the far right of it!

Try setting Focus (using the Form_Current event) to a Control in the Subform's far, upper left, area.

Linq ;0)>

--------------------
BTW...The Monkey is laughing at me...not at any other poster!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
hemant
post Mar 28 2020, 06:32 AM
Post#4



Posts: 81
Joined: 19-February 20
From: Mumbai, India


Thanks BB. It was due to Tab Order. Now it is sorted.
Thanks Linq for replying.
Go to the top of the page
 
BentBrain
post Mar 28 2020, 06:49 AM
Post#5



Posts: 563
Joined: 10-February 03
From: Thailand


Glad to help.

Enjoy the world of MS Access

BB

--------------------
"There is no excellent beauty that hath not some strangeness in the proportion" Francis Bacon
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    27th May 2020 - 01:07 AM