Microsoft Access Report Printing

[Tom Fischer]

I have a database where some fields have data, while
others do not. I want to set up my report so that the
fields that do not have data, do not print and only the
fields that have data will print. I have been unable to
find the answer in help and would appreciate any
assistance.

Thanks

 

[Wayne Morgan]

As long as there is NOTHING else in line with the control horizontally (even
a partial overlap will prevent this from working) you can use the Can Shrink
property of the control. If you set it to Yes then it will shrink to zero
height if there is no data for that record. If you don't need the section to
be a fixed height, such as when printing on labels, you can also set the Can
Shrink property of the section to Yes.

Another option is to concatenate the fields into a single control using a
"calculated textbox". To do this, you would set the control source of the
textbox to something like:

=Trim([Field1] & " " & [Field2])