none
Block column in continuous form RRS feed

  • Question

  • I have a continuous form displaying 30 fields. I can't see all the fields in one view, so I have to scroll from left tot right.
    In a table I can block 1 or more fields/columns at the left-side to prevent them scrolling of the screen. I would like to also do this in my continuous form, but I can not find a way to do that.
    Is this possible? And how?

    Monday, July 11, 2016 3:36 PM

Answers

  • Using VBA should not be a problem, I have some experience with VBA,
    But, in this case I don't know where to start, so could you help me on teh way?

    Hi ArnoJeroen,

    It is handy to have a table wherein you describe the Control names, including the Left property of the control, e.g.

        Ctl_name    Left
    |     Ctl1              1
          Ctl2               2
          Ctl3               4
          Ctl4            5,5
          ...

    I gave the Left property arbitrary unit, but the best is to express it in twips (1440 per inch).

    If you want to have Ctl1 static, and continue with Ctl4 and on, you make Ctl2 and Ctl3 invisible, and reduce the Left property of all control from Ctl4 and on with the value (5,5 - 2), that is Ctl4 moves to the position of Ctl2, etc.

    On the form you need a command button to initiate this action. All is done in memory, it does not change the defaults of the form.

    If you understand the principle, it should not be too difficult to make a nice "shift register". Moving the other way is just the same principle with an increase of the Left property of the controls, and making the necessary control visible.

    Imb.

    Tuesday, July 12, 2016 2:17 PM

All replies

  • I have a continuous form displaying 30 fields. I can't see all the fields in one view, so I have to scroll from left tot right.
    In a table I can block 1 or more fields/columns at the left-side to prevent them scrolling of the screen. I would like to also do this in my continuous form, but I can not find a way to do that.
    Is this possible? And how?

    Hi ArnoJeroen,

    As far as I know there is no standard Access function to do this.

    But if you are willing to use VBA, it is possible to make such a functionality.

    Imb.

    Monday, July 11, 2016 5:34 PM

  • Hi ArnoJeroen,

    As far as I know there is no standard Access function  to do this.

    But if you are willing to use VBA, it is possible to make such a functionality.

    Imb.

    Using VBA should not be a problem, I have some experience with VBA,
    But, in this case I don't know where to start, so could you help me on teh way?
    Tuesday, July 12, 2016 1:28 PM
  • Using VBA should not be a problem, I have some experience with VBA,
    But, in this case I don't know where to start, so could you help me on teh way?

    Hi ArnoJeroen,

    It is handy to have a table wherein you describe the Control names, including the Left property of the control, e.g.

        Ctl_name    Left
    |     Ctl1              1
          Ctl2               2
          Ctl3               4
          Ctl4            5,5
          ...

    I gave the Left property arbitrary unit, but the best is to express it in twips (1440 per inch).

    If you want to have Ctl1 static, and continue with Ctl4 and on, you make Ctl2 and Ctl3 invisible, and reduce the Left property of all control from Ctl4 and on with the value (5,5 - 2), that is Ctl4 moves to the position of Ctl2, etc.

    On the form you need a command button to initiate this action. All is done in memory, it does not change the defaults of the form.

    If you understand the principle, it should not be too difficult to make a nice "shift register". Moving the other way is just the same principle with an increase of the Left property of the controls, and making the necessary control visible.

    Imb.

    Tuesday, July 12, 2016 2:17 PM