Results 1 to 5 of 5
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Print Preview on Form acting Strange (A2K, SR1)

    I have a form that has 5 Charts inserted into it. The chart values/views change as the user selects a record from a combo box.

    The problem is this. When selecting print preview, the system shows multiple pages (I don't know how many since when I try to get to the last page, the system runs out of memory) even though there are only five charts with a limited amount of data. When paging through the preview, several of the graphs are shown multiple times. Why is Access doing this and does anyone know how to correct it?

    Thanks
    Regards,

    Gary
    (It's been a while!)

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Preview on Form acting Strange (A2K, SR1)

    Sounds like you have a "Join" problem in the record source query.
    You also say "form" and "print review" ..... you should be using a report. Forms are not designed to be printed.

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Print Preview on Form acting Strange (A2K, SR1)

    I am not sure what the problem is, but it is not a join problem as the query on extracts data from one table. I did take your advice and have the form create a report to print the graphics which prints the data correctly.

    Thanks
    Regards,

    Gary
    (It's been a while!)

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Print Preview on Form acting Strange (A2K, SR1)

    The problem is that forms always print the entire recordset, not just the current record. That's one of the biggest gotchas with printing forms.
    Charlotte

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Print Preview on Form acting Strange (A2K, SR1)

    Thanks everyone for your input.

    Charlotte, you have provided another tidbit of valuable information that I did not know. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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