[AccessD] Freeze panes

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>
>