Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / May 2005

Tip: Looking for answers? Try searching our database.

Make labels always visible as user scrolls right

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Chace - 02 May 2005 21:19 GMT
I am designing my forms to fit 600 x 800 resolution.  I have more horizontal
real estate on the form than the screen size can show, therefore my user will
have to use the horizontal scroll bar to move left to right on the form.  My
problem is that I want the left most controls (which are labels) to always be
visible as my user scrolls to the right.  (The concept would be similar to
"freezing panes" in Excel) This will be helpful to ensure the user is putting
the right data in the right text boxes.  I am struggling with a clean
solution for this....any ideas.  I hope I am missing something simple........

Thanks for your help,
Chace
Kevin R - 03 May 2005 01:22 GMT
Make a new form containing your form as a subform,
then on the new form (the parent form) you can put labels
next to each row and the horizontal scrollbar on the subform
wont affect the lables.

Kevin R

>I am designing my forms to fit 600 x 800 resolution.  I have more horizontal
>real estate on the form than the screen size can show, therefore my user will
[quoted text clipped - 7 lines]
>Thanks for your help,
>Chace
Chace - 03 May 2005 03:07 GMT
Good idea.  I will give that a try too.  As I was searching for similar
issues I found Leban's code that returns the scroll bar position.  Then I
assigned the .Left property of the Labels I wanted to move to the scroll bar
position and it works pretty good.  it updates on the form timer event every
250msec.  

Your way is probably better......and shouldn't take much effort.   Thanks
for the idea.

Chace

> Make a new form containing your form as a subform,
> then on the new form (the parent form) you can put labels
[quoted text clipped - 14 lines]
> >Thanks for your help,
> >Chace
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.