How to Print a MSFlexGrid ?? 2

[JohnBates]

Hi everyone -

My form contains a MSFlexGrid control.

When I use PrintForm, the resulting printout is just the
out line of the form.... the detail data within the
grid is blank. I tried setting focus to the MSFlexGrid
prior to the PrintForm... but still get blank form. :-(

hmmm.... how do you print a MSFlexGrid ?

Thanks for any tips.
John

 

[HermanvLimbeek]

Hi John,

Option 1. Cycle through all rows and cols in the grid and send them to the printer.

Option 2. Export the grid to Excel and use Excel-methods to address the printer.

Herman :-Q

 

[JohnBates]

Thanks to Herman and vbNewbie for your ideas-

vbNewbie, your idea of printing the flexgrid via a Picture
control worked... after a little tweaking.

You're brilliant! (and I wouldn't call you a "newbie&quot

Thanks alot. John