Print Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ghagg - 30 Jul 2008 21:18 GMT

I have used the following code to print contents of a listbox, which works
well. One little problem, this print function only prints a 1" wide column.
What can i do something to widen the column to say 2" or more?

Thanks
gh

Private Sub cmdPrintClass1_Click()
CurrentDb.QueryDefs("PrintQuery").SQL = Me![ListClass1].RowSource
DoCmd.OpenQuery "PrintQuery"
DoCmd.PrintOut
DoCmd.Close acQuery, "PrintQuery"
End Sub

Reply to this Message

Douglas J. Steele - 31 Jul 2008 01:25 GMT

Realistically, queries aren't intended to be printed. Create a report that's
formatted how you want it, and then print the report.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have used the following code to print contents of a listbox, which works
>well. One little problem, this print function only prints a 1" wide
[quoted text clipped - 9 lines]
> DoCmd.Close acQuery, "PrintQuery"
> End Sub

Reply to this Message