ACCESS FEED: Re: [MS_AccessPros] Constant number of lines on a report

Kamis, 27 Oktober 2011

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
>