Results 1 to 5 of 5

Thread: report (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report (2k)

    i want to adjust the report in view mode in the middle of the page . no use scrole bar .
    Thanks
    Ashraf

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    I'm not sure what you mean. You can make a report display the entire page if you use code to open it, for example from a command button on a form:

    Private Sub cmdOpenReport_Click()
    DoCmd.OpenReport "rptMyReport", acViewPreview
    RunCommand acCmdFitToWindow
    End Sub

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    it is ok if i open my rbt from a form but if i have not form how i fit the report to the window .
    Thank u
    Ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    If you want to do this interactively, just open the report and press the Z key.

    If you want to automate it, you can create a macro to open the report and fit it to the window.
    - Create a new macro
    - Select OpenReport as first action, and specify the name of the report in the first argument, and Preview in the second argument.
    - Select RunCommand as second action, and specify Fit to Window as argument.
    - Save the macro.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    Thank u , it 's work good

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •