Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Forms (Microsoft Access)

    I created a form that I would like the user to be able to print when they hit the command button. My problem is that the form is printing in two pages. Is there any way to set up the form to print on one sheet. Thanks for your help.

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

    Re: Printing Forms (Microsoft Access)

    Forms are not really meant to be printed. It's best to design a report that displays the records the way you want, and open or print that from the command button. If you want to display/print only the current record in the form, you can specify a filter (where-condition) for the report. Say that the record is identified by a field ID.

    Private Sub cmdPrint_Click()
    If Me.Dirty Then
    ' Make sure the record is saved
    RunCommand acCmdSaveRecord
    End If
    DoCmd.OpenReport "rptMyReport", acViewPreview, , "[ID] = " & Me.[ID]
    End Sub

    The above assumes that ID is a number field. If it is a text field, change the code to

    ..., "[ID] = " & Chr(34) & Me.[ID] & Chr(34)

    To print directly instead of previewing, change acViewPreview to acViewNormal or omit this argument (but keep the comma)

  3. #3
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Forms (Microsoft Access)

    Well, my form doesn't have "records" or "fields" in it. It was used just to display data. It isn't going to be changed or queried upon. I am sending a print screen of the form. If you have a better way of showing this information please let me know. It was basically a word document previously and I was asked to place it into our database so that the information is viewable to the user.

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

    Re: Printing Forms (Microsoft Access)

    So how does the form get populated?

  5. #5
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Forms (Microsoft Access)

    I created text boxes and typed the data in myself. It isn't linked to any tables.

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

    Re: Printing Forms (Microsoft Access)

    Yuck! <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>

    You can do one of the following:
    - Rearrange the text boxes on the form until the printed output fits on a page.
    - Create a blank report, then copy and paste the text boxes from the form onto the report and arrange them in such a way that the report prints on one page.
    - Your printer may support printing two pages on one sheet of paper.
    - If you can create a .pdf file from the form, the Adobe reader has options to print multiple pages on one sheet of paper.

  7. #7
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Forms (Microsoft Access)

    Thanks, I'll try that.

  8. #8
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Forms (Microsoft Access)

    You may try to print the form in landscape.

    If that dosen't work go to Page Setup, adj Top, Bottom, Left and Right to 0

    HTH

    John

  9. #9
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Forms (Microsoft Access)

    Thanks, that did help.

Posting Permissions

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