Trimming a Form When Printing - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Trimming a Form When Printing

Thomas Corbett

4 years ago

Hi Everyone, My question is that I am able to trim on display to show only fields with information but this does not carry through to printing or emailing. Any help would be appreciated :)

Thanks

Tom -

	Adam Schwanz @Reply 4 years ago
Just verifying, you mean report not form right? Are you using can shrink or can you upload any images of what is happening? Image Uploads

	Thomas Corbett OP @Reply 4 years ago
Hi, as I said the on display is working correctly "=IIf(Trim(Nz([Product1],""))="","","Product 1")" but when using an email function in PDF format the trim is not displaying properly when you open the PDF, the space for data is being displayed as blank so one page ends up being multiple pages one with the data and the remainder with the blank spaces.

	Richard Rost @Reply 4 years ago
Screen shot? I can't picture it.

	Thomas Corbett OP @Reply 4 years ago
Hi Rich, sending it to your email

	Richard Rost @Reply 4 years ago
No, please keep all technical questions here in the Forums. There's a link at the top to post screen shots.

	Thomas Corbett OP @Reply 4 years ago
Unfortunately I cannot as the data is confidential. I believe the problem is that I am mailing the data using a macro and outputting in PDF format. I believe I may need to do this in VBA instead to match the displayed info.

	Richard Rost @Reply 4 years ago
OK. It's just hard for me to tell what's going on without being able to see it. You could always black out sensitive data.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View