Freeze pane effect on form

[Geraint]

I'm not sure how to achieve this or whether or not it is
possible.

I have a continous form as a spreadsheet that is quite
wide and goes off the right hand side of my screen. I
need to effectively freeze a textbox on the left hand
side when scrolling to right to enable users to view the
textbox value at all times. I know I can do this using
table layout view but I don't want to do this for a
variety of reasons.

I'm sure I should be able to use the Left property of the
textbox control and somehow link it to the scroll bar
value? I'm sure it's possible in vb to access scrollbar
values but can't see how to do it in Access.

Can anyone help me with this or suggest a neater way of
achieving the same.

Any help apreciated.

Geraint

 

[DanK]

One way I dealt with this was that I put the field in the
row TWICE. Once at the far left and again at WHAT
APPEARED to be the far left of the second (right-hand
side) part of the page. Another way to deal with this is
to have a pop up form appear with the needed info.
Another way would be to have a control APPEAR that was in
the Header of the (Master) form.

Are you SURE you don't want to just create TWO rows of
information and keep it all on one screen?!

 

[Geraint]

Thanks for response Dan

All good and valid responses - I think I may go with the
Control in the header, that would work OK.

I have seen another bit of coding that traps the
horizontal scroll bar value but it looks way too
complex. It would probably be the neatest way of doing
it, but I just don't have the time.
A control in the header is quick, simple and will do the
trick nicely. many thanks.