Freezing column or section on a form

[Guest]

Hi

Like you can freeze a column on the datasheet view i was wondering if there
is a way you can do this on a form. I want to freeze it from a certain point
on the form, if possible like in excel i want to freeze a down and across so
my left hand labels and top labels stay in view at all times when the user
scrolls down and across.

Is this possible at all, maybe using subforms or other forms.

One way i thougth was to put a form over the top but that form needs to be
always on top as when the user uses the scroll bar on the form below the for
that was put over the top goes behind.

I would appreciate any help or ideas that you have as i have been tryin to
sovle this for a while now.

Cheers

Danny

 

[Guest]

Hi Daniel

You could create a single view form with a datasheet subform.

Place the "Top Lables" in the main form header and the "left hand lables" on
the details ection of the main form. You would need to play around a little
to line up the datasheet rows with the detail lables but it would only take a
few mins.

Hope this helps

--
Buon Natale, Happy Chritmas.

Wayne
Manchester, England.
Scusate,ma il mio Inglese fa schiffo
Percio se non ci siamo capiti, mi mandate un
messagio e provero di spiegarmi meglio.