Can Shrink Property - fields on exported PDF

[Snowflake68]

I have managed to produce a report that shrinks and hides null fields very well when viewing the report on screen, however when I export the report to a PDF or .Doc file it contains the blank lines where the null fields would be.

Is there a way to eliminate these. Would really appreciate some help.

Thanks

 

[sneuberg]

How are these null fields being shrunk and hidden? If the entire line is blank can't that data be eliminated in the reports query?

Access's Word output sucks, but I'm a bit surprised that a PDF looks different that the report. I thought they got that right. I'm very curious about this.

 

[Snowflake68]

How are these null fields being shrunk and hidden? If the entire line is blank can't that data be eliminated in the reports query?

Access's Word output sucks, but I'm a bit surprised that a PDF looks different that the report. I thought they got that right. I'm very curious about this.

I have code in each of the text box's Controls Source as well as the 'Can Shrink'/'Can Grow' property set to Yes. Each text box is on a separate line vertically beneath each other (otherwise it wont work)

This is an example to show a label called 'Bottle:' with a field value for Bottle.

=IIf([Bottle] Is Null,Null,"Bottle: " & Format([Bottle],"Currency"))

The Preview of the report works a treat but when I export it the PDF isnt formatted in the same way which is a shame as this is the whole point of the report.

Just wondered if there was a way to do it in the PDF and Word Doc.