Print Preview in VB

[Guest_imported]

Dear Friends

Is there any simple function to perform the print preview; I need this function to preview the desired printing before the user confirm the print command; your fast reply will be highly appreciated

Thanks all

 

[zeevgetner]

what you nead to do is find a reporting tool and use it. i tired for 2 months to print in v.b and realized it is a hard mission. you might consider using word or powerpoint to send things throw vba.

if you tell me exactly what you want to do i can help you some more

zeev

 

[sunaj]

Hi,

Printing from VB is not easy and you might consider Zeev suggestion, but it is possible! also with a preview:
- Declare a variable 'MyPrint as variant' and 'Set MyPrint=form1'
- Place everything on the form using MyPrint.currentX and .currentY .print and .pset, .line etc. This will make up your preview.
- 'Set MyPrint=printer' and run the same code that showed the preview on the form and it will come out on the printer as it was shown on the form.

Good luck X-)
Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[tppradeep18]

I dont think its that hard. There are some readymade source code available in MSDN. check out.