[AccessD] Freeze panes

What about using a subform?

Only display the scrollbars for the subform.

On Sat, Feb 18, 2012 at 9:27 AM, Doug Steele <dbdoug at gmail.com> wrote:

> I did this once, but I cheated.  I have two sets of text boxes with the
> 'frozen' data, one set at the left end of the screen and one just out of
> sight past the right edge of the screen.  I don't give the user a
> horizontal scrollbar.  When the user tabs or arrows off the right hand end
> of the 'first' screen, I force the focus to a tiny field at the right hand
> end of the current row.  This automatically makes the second set of
> 'frozen' text boxes jump to the left hand side of the screen, with the text
> boxes for the 'second' screen showing.  The reverse happens when the user
> Shift-Tabs or left arrows to the left of the first 'unfrozen' text box in
> the second screen.  I also let them use the Home and End keys to switch
> back and forth between the two views.
>
> Doug
>
>
> >  Dear List:
> >>
> >> I have a client who wants a list of persons and companies on a form, and
> >> following the person name and company, wants several other fields. All
> the
> >> fields won't all fit on the display, so a horizontal slider bar is OK to
> >> see
> >> the fields hidden off to the right off the screen.
> >>
> >> However, he would like the person name and company name not to slide off
> >> to
> >> the left as he slides to the right - similar to the Freeze Panes
> function
> >> in
> >> Excel.
> >>
> >> I haven't really thought about a technique to do this, but maybe there's
> >> some standard way to do this -  yet another Access function that I don't
> >> know about?  Or someone like Lebans has already done it?  Has anyone
> done
> >> this before?
> >>
> >> MTIA
> >>
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/**mailman/listinfo/accessd<
> http://databaseadvisors.com/mailman/listinfo/accessd>
> > Website: http://www.databaseadvisors.**com<
> http://www.databaseadvisors.com>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>