Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Suppress Detail Printing (Access 2003)

    I
    Cheers,
    Andy

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

    Re: Suppress Detail Printing (Access 2003)

    Use the On Format event of the Detail section:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = (Me.txtNeeded < 1)
    End Sub

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppress Detail Printing (Access 2003)

    So little code, such marvellous results! Thanks Hans.

    And while I
    Cheers,
    Andy

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

    Re: Suppress Detail Printing (Access 2003)

    You could set the number of columns to 10 in the Columns tab of File | Page Setup.
    Don't forget to change the column width and the spacing between columns, otherwise the columns won't fit on the page.

    You can set the Control Source of a text box on a subreport to

    =[Parent]![NameOfTextBox]

    Parent refers to the main report. If you open the subreport by itself, you'll see #Error because Parent is invalid in that situation.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppress Detail Printing (Access 2003)

    Thanks Hans,

    I'd already attempted the columnar thing in Page Setup, but it affects the whole report and I was trying to columnize ( is there such a word? ) just the Detail Section.

    Cheers, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Cheers,
    Andy

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

    Re: Suppress Detail Printing (Access 2003)

    The page header and footer and the report header and footer can go across the entire width of the page.
    Group headers and footers will have the same width as the columns, however.
    If that is not what you want, you'll have to use a subreport. Or use a query that concatenates the values.

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppress Detail Printing (Access 2003)

    Thanks again Hans,

    I'm working on the subReport scenario even as we speak ( type? ) with semi-dubious results so far, but going in the right direction. I'll probably be getting back to you with further anomalies or dehancements.

    Cheers, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Cheers,
    Andy

  8. #8
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppress Detail Printing (Access 2003)

    OK, I warned you I
    Cheers,
    Andy

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

    Re: Suppress Detail Printing (Access 2003)

    It is not always predictable when Access thinks that square brackets around names are needed in expressions, so that's nothing to worry about.

    Without seeing the database it's impossible to know why the expression doesn't work. I'd start with a very simple expression, and if that works OK, add to it bit by bit, checking whether it still works at each stage.

  10. #10
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppress Detail Printing (Access 2003)

    Thanks Hans,

    I thought it was something I'd done/not done. I'll do some mini-testing and see what happens.

    Chhers <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Cheers,
    Andy

Posting Permissions

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