Dealing with spare text boxes in a report

[stgill]

The detail section in my report contains 5 text boxes - these are grouped according to one field in the table that contains the data.

My problem is that, when inputting the data, not all fields will be used all of the time. Sometimes, the report will show all 5 text boxes with data, sometimes less. When there are spare text boxes, I have a lot of white space on the report (in the detail section between groups) that I need to get rid of.

The can grow/shrink properties are set to yes, but the unused text boxes do not move up. Can text boxes move up or down according to whether the text boxes around them contain data?

Any ideas appreciated.

 

[dhookom]

Your detail section will only "recover" the space or allow the section to shrink if there are no control along the same horizontal line. Are the values Null or zero-length-strings?

Duane
MS Access MVP

 

[stgill]

The data type set for the text boxes is Text, so I suppose the values will be zero-length-strings.

Peter

 

[dhookom]

If you have text boxes to the left or right of the box you want to shrink, there will still be white space remaining.

Duane
MS Access MVP