ACCESS FEED: Re: [MS_AccessPros] Columns in a report

Minggu, 19 Oktober 2014

Re: [MS_AccessPros] Columns in a report

Thanks Rajiv,

I failed in my first attempt and I will return to the problem and get your solution working as soon as I get a chance.

Regards,

Robin

At 18/10/2014 07:04 PM, you wrote:

Another approach:

Add an unbound text box to the line with your data - call it txtLNO
Add a pagebreak below the data line - call it pb
Now add tis code in the on format event for detail section of the report:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtLNO & "" = "" Then Me.txtLNO = 1

Me.txtLNO = Me.txtLNO + 1
If Me.txtLNO = 5 Then
Me.pb.Visible = True
Me.txtLNO = 0
Else
Me.pb.Visible = False
End If

End Sub

Rajiv
On 18 Oct 2014 12:47, "John Viescas JohnV@msn.com [MS_Access_Professionals]" < MS_Access_Professionals@yahoogroups.com> wrote:

Â

Robin-

It sounds like you want a Label layout - 4 across and 5 down. Try using the Report Label wizard.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Oct 18, 2014, at 7:23 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

I am using Access 2013. I am attempting to make a report with four columns.

The report is a single field intended to be 20 records per sheet.

How do I limit the report to print five lines of data per page?

Many thanks,

Robin Chapple

------------------------------------

Posted by: Robin Chapple <robinski@westnet.com.au >

------------------------------------

------------------------------------

Yahoo Groups Links