Is there a way to print a form without the footer. I'm using the "DoCmd.Printout acSelection" as code behind a command button. The current record in the form on the screen prints ok but I also get the footer which contains the command buttons.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: