Print Query

  • Thread starter Thread starter Ghagg
  • Start date Start date
G

Ghagg

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
 
Realistically, queries aren't intended to be printed. Create a report that's
formatted how you want it, and then print the report.
 
Back
Top