Re: Help With Print Preview

From: Peter (peterguy)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 13:35:12 -0800

Do you have to preview only that range?

PrintPreview applies to the Work*** object, at least in Office 2002, so wrk***.PrintPreview should preview the whole ***..

hth,

-Peter

"Reginald Johnson" <reginald.johnson@cox.net> wrote in message news:_Jzld.1681$Qj.993@lakeread07...
> Hello,
> I have an Access Form with a Tab Control in it. On one of the Tab
> controls I have a MS Spread*** Control. I've worked through the
> problems I've had so far, and the work*** works as I want it to.
> However, I am unable to Print Preview it. As of now, my code looks like
> this:
>
> Public Function FuncPrintPreview (frmMe as Form)
>
> Dim wrk*** as Work***
> Set wrk*** =frmMe.SprdTracker.Active***
> wrk***.Range("A1:N14").PrintPreview
>
> End Function
>
> However, it doesn't look like Print Preview is a method of any sort that
> is associated with a work*** object. Does anybody have an idea on
> how to do this?