On 16 May 2004 21:32:29 -0700,
so**********@hotmail.com (Aravind) wrote:
Hi folks.
I have a form that has a form header and form footer, which has a few
command buttons. When I open the form, I have to scroll the form from
left to right to view my data. The thing is, the buttons in the header
and footer will also scroll from left to right. How do I prevent this,
i.e. make the buttons stay put?
Put the buttons on an unbound master form, and everything else in the detail
form, and have the scrolling happen in the subform.
The only problem with that is that resizing the master doesn't resize the
subform, but that can be fixed by capturing the Resize event on the master
form. If you do try this, it's a good idea to put any master form buttons
that are below the subform in the master form's footer, so you don't have to
reposition them as well as resizing the subform.