Freezing columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform in which the default view is set to Continuous Forms.

I'd like to freeze the first three column on the lift hand side so that as
one goes to the right, still be able to see the account code and description.
I am able to do it in datasheet view but want the Continuous Forms view.

Any suggestions?

Arnon
 
I have a subform in which the default view is set to Continuous Forms.

I'd like to freeze the first three column on the lift hand side so that as
one goes to the right, still be able to see the account code and description.
I am able to do it in datasheet view but want the Continuous Forms view.

Any suggestions?

Arnon
Click to expand...

Try two subforms side by side, one with the three columns, the other
with the remaining ones.

John W. Vinson[MVP]
 
John,
I was "lurking" to see what solutions would come up for this problem.
I have to ask... how would you keep the left sub from getting out of
synch "vertically" with the right sub? (Since they are both continous
subforms, they would probably each need a vertical scroll bar, with the
right sub also having a horizontal scroll bar)
Thanks,
Al Camp
 
Arnon,
In the past, I removed the horizontal scroll bar from the subform and
replaced it with 2 buttons in the sub footer.
A < and a > button.
I repeated the frozen column in the sub like this... (I'll use just one
frozen column (PONo) as an example)
PONo Field1 Field 2 PONo Field3 Field4

Then I coded the > button to do a GotControl Field4 and the < button to
GoToControl PONo.
The whole subform shifts, but because there's now a second (copy) PONo
on the left of the sub... it appears as though the other fields "shifted"
while PONo appeared to stay frozen.

You'll have to expirement with the GotoControl and your field sizes, but
eventually you can make it look just like PONo is anchored while your other
fields "appear" to the right. You can even create a hidden control to GOTO
so that the shift aligns properly... back and forth. Be prepared to do a
bit of "finagaling"... it does work.
 
In the past, I removed the horizontal scroll bar from the subform and
replaced it with 2 buttons in the sub footer.
A < and a > button.
Click to expand...

VERY clever...


John W. Vinson[MVP]
 
I have to ask... how would you keep the left sub from getting out of
synch "vertically" with the right sub?
Click to expand...

Didn't think it through to that point, Al - good point! I guess in
each subform's Current event you could detect the current
absoluteposition using a recordset, and adjust the position of the
other. Tricky...

John W. Vinson[MVP]
 
Back
Top