Access 13 Reports variable row length

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

Answer 1

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.

Answer 2

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...

Answer 3

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