Jenn-
If you're hiding the controls, then the duplicates should not appear. You
clearly are getting it done when there's 1 line. If you weren't hiding the
controls at all, I would expect you to see the one line repeated three times.
Try single-stepping through your code to try to figure out what's happening.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of JD
Sent: Thursday, October 27, 2011 4:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Constant number of lines on a report
John,
Thank you for your reply. I did hide the display control for all fields
associated with this. I am at a complete loss as to why this is happening but it
makes me feel a little better to know that I am not alone in my lack of
understanding why it is.
I guess I will try to find another solution. I am writing this for a company
and cannot afford to have it appear buggy.
Again, thank you.
Jenn D.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Jenn-
>
> I have no clue why it works for 1 and 3 but not 2. Notice in the sample code
> that it hides the display control when "skipping" a line. This may be
necessary
> to do for all the controls to prevent displaying the same data again.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of JD
> Sent: Thursday, October 27, 2011 3:25 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Constant number of lines on a report
>
> Hello all,
>
> I have a report that I need to have 3 records show per page. I have followed
> the Microsoft Support article ACC2000: How to Print a Constant Number of Lines
> Per Group and it works for the most part. The only issue that I am fighting
> with is this...
>
> If I have 1 record it works fine, I get that record and 2 blank lines on my
> report. If I have 3 records, it works fine, I get 3 records on my report. My
> issue is if I have 2 records. It prints both records and then repeats the 2nd
> record in space #3. I have tried increasing the number of constant lines but
I
> always get the same result. If I have one less record than the number of
lines
> that I define, it always repeats the last record.
>
> Can someone explain to me why? If I need to supply any additional
information,
> please let me know. I am using MS Access 2010.
>
> Help!!
>
> Jenn D.
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar