Re: Re-Post: FitToWindow
From: fredg (fgutkind_at_example.invalid)
Date: 07/27/04
- Next message: Rick B: "Re: field justification"
- Previous message: Fons Ponsioen: "data from other queries on a report"
- In reply to: Ashley: "Re: Re-Post: FitToWindow"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Jul 2004 21:19:50 GMT
On Tue, 27 Jul 2004 12:55:04 -0700, Ashley wrote:
>>-----Original Message-----
>>"Ashley" <anonymous@discussions.microsoft.com> wrote in
> message
>>news:522d01c4740f$68a43560$a601280a@phx.gbl...
>>>
>>> >-----Original Message-----
>>> >On Mon, 26 Jul 2004 15:16:46 -0700, Ashley wrote:
>>> >
>>> >> Could I have the report to open in the "fit to
> window"?
>>> >> Anyone know how to write a command on report open?
>>> >>
>>> >> Thanks
>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> >If you open the report from an event on a form, use:
>>> >
>>> >DoCmd.OpenReport "ReportName", acViewPreview
>>> >DoCmd.RunCommand acCmdFitToWindow
>>> >--
>>> >Fred
>>> >Please only reply to this newsgroup.
>>> >I do not reply to personal email.
>>> >.
>>>
>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>> >I got Run-Time Error '2046':
>>> This command or action 'FitToWindow' isn't available
> now.
>>> How can I fit this error?
>>> Ashley
>>> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>
>>Where did you put the code?
>>
>>
>>--
>>I don't check the Email account attached
>>to this message. Send instead to...
>>RBrandt at Hunter dot com
>>
>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> I put the code in the Report Event on Open.
>>Ashley
>>>>>>>>>>>>>>>>>>>>>>
It doesn't belong in the Report Open event.
>>> >If you open the report from an event on a form, use:
>>> >DoCmd.OpenReport "ReportName", acViewPreview
>>> >DoCmd.RunCommand acCmdFitToWindow
If you open the report by means of a command button on a form, the
code goes in the command button Click event, just under the OpenReport
line, exactly as I indicated above.
-- Fred Please only reply to this newsgroup. I do not reply to personal email.
- Next message: Rick B: "Re: field justification"
- Previous message: Fons Ponsioen: "data from other queries on a report"
- In reply to: Ashley: "Re: Re-Post: FitToWindow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
