Excel Style Lock on continuous form

[darrentaylor555]

Hello

I have a very wide continuous form, the width of the form has been reduced to the smallest width.

Is there any way of 'locking' some of the first textboxes, like you can in excel so they are visible all the time using the horizontal scroll.

Thanks
Darren

 

[adam_fleck]

Freeze Columns?

If you were to show your form as a datasheet (though this might not give you some of the extra things you need) then you could select the columns you want to pin, and use Format, Freeze Columns to make them stick. Save the form, and the freeze will be saved too.

If showing the form as a datasheet is not an option, but the form will be viewed as a subform on a main form, then you could design a new subform for the boxes you want to freeze, delete these boxes from the existing wide form, then put the two subforms right next to each other on your main form. If you set the master/child properties so that they're the same for both subforms it should look like you've frozen the boxes in the left-hand subform.

 

[ChrisO]

This attachment is very similar to Adam’s suggestion.

Although it uses an ActiveX scroll bar I’ve been told that it works from A97 to A2K3.

Hope that helps.

Regards,
Chris.

 

[darrentaylor555]

Thankyou very much, the mdb has pointed me in the right direction, I now have my 'locked' fields on my form.

Once again, thankyou very much.