Can Shrink Property - fields on exported PDF

Snowflake68

Registered User.
Local time
Today, 12:20
Joined
May 28, 2014
Messages
464
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
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom