VB and VBA Users Source Code: Re: Print the contents of an MS FlexGrid

VB/VBA Source Code
Re: Print the contents of an MS FlexGrid

By:	Shabbir
Email (spam proof):	Email the originator of this post
Date:	Monday, December 23, 2002
Hits:	1023
Category:	Database/SQL/ADO

Article:
'You might want to set certain propties.... fgprint.toprow=1 ' make sure to print from the top of the grid... 'place printer.orientation 'within the loop so that the next page to print has the same property as the first 'place this instead to print all the colums jsut in case there too many columns Printer.PaintPicture fgPrint.Picture, lLeftBorder, lTopBorder, 11400, lHeadingHeight, , 0, , lHeadingHeight ' for verticle (11400 this can be adjusted if you only few colums) and Printer.PaintPicture fgPrint.Picture, lLeftBorder, lTopBorder, 15000, lHeadingHeight, , 0, , lHeadingHeight ' for horizontal
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder