see attachments. any ideas would be appreciated. thanks
see attachments. any ideas would be appreciated. thanks
First image is the print? What is wrong?
If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
1st image is what it prints like, 2nd image is what is shows prior to print. look at the space to the right of the Line Total on the 1st image of how it actually prints.
And there was me thinking it was the coloured rows not being the same?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I would have to examine report in design view.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DaveGRI has nailed it. The form (subform/ sub report) has space allowed on it for the scroll bar.
Obviously that vanishes when it's rendered for printing, hence the mis-alignment
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Are you using a form as a subreport? Build a report instead.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.