none
Access 13 Reports variable row length RRS feed

  • Question

  • I have a quotation report which have up to 5 textboxes for quantities on each row.  And it works just fine. I now need to hide say the 2nd and 4th textboxes (they are empty). Which using the textbox  visible property works ok.  But it leave a gap between 1st and 3rd textbox, and 3rd and 5th textbox on the report.  I need to be able to move the 3rd textbox to where the 2nd was positioned together with the 5th textbox moved the  3rd postion.  Or to put another way remove the white space between textboxes where they are zero or empty.  Hope this clear.

    xjohn

    Sunday, January 10, 2016 7:20 PM

Answers

  • Hi xjohn,

    If you doesn't need those field, you can select and remove those text control. And if you just want to remove the space, you can set their width to 0. And you also see the space is different with other control, we can set the left and right padding to 0.

    In addition, here are some helpful article about Access report for you reference:
    Introduction to reports in Access

    Create a simple report

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, January 11, 2016 2:02 AM
    Moderator
  • Hi xjohn,

    Are you talking about having unbound textboxes on your report? In any case, take a look at the Can Grow and Can Shrink properties of the report. You can set the height of a textbox to 0" and with the Can Grow property set to Yes, it will still display the contents when it's not empty.

    Hope that helps...

    Monday, January 11, 2016 2:37 AM

All replies

  • Hi xjohn,

    If you doesn't need those field, you can select and remove those text control. And if you just want to remove the space, you can set their width to 0. And you also see the space is different with other control, we can set the left and right padding to 0.

    In addition, here are some helpful article about Access report for you reference:
    Introduction to reports in Access

    Create a simple report

    Regards & Fei


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, January 11, 2016 2:02 AM
    Moderator
  • Hi xjohn,

    Are you talking about having unbound textboxes on your report? In any case, take a look at the Can Grow and Can Shrink properties of the report. You can set the height of a textbox to 0" and with the Can Grow property set to Yes, it will still display the contents when it's not empty.

    Hope that helps...

    Monday, January 11, 2016 2:37 AM
  • Hi Fei

    Thank you for the idea of setting the width to zero, that had not occurred to me and thankx for the references.

    Regards

    xjohn 

    Monday, January 11, 2016 10:15 AM