| | |
|
|
|
Number Pages in loop sequence |
|---|
| message from =?Utf-8?B?RGF2aWQ=?= on 12 May 2004 |
I have a report that I need to have the numbers 1-7 on. It does not matter how many pages are in the report. Each page must be numbered sequentially 1-7 tnen loop, return to 1 to start the numbering process again.
Any help would be greatly appreciated.
Thank you in advance
David
|
| Luiz Cláudio replied to =?Utf-8?B?RGF2aWQ=?= on 12 May 2004 |
Hi David,
Private Sub Report_Page()
Static pgNumber As Integer
pgNumber = pgNumber + 1
Me.ForeColor = vbBlue
Me.FontItalic = True
Me.FontBold = True
Me.CurrentX = 2000
Me.CurrentY = 15
Me.Print CStr(pgNumber)
If pgNumber >= 7 Then pgNumber = 0
End Sub
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
"David" <anonymous@discussions.microsoft.com> escreveu na mensagem
news:DAD2A927-6144-4235-88D8-498F0113DCA1@microsoft.com...
matter how many pages are in the report. Each page must be numbered
sequentially 1-7 tnen loop, return to 1 to start the numbering process
again.
in? I am thinking that I will have to use VBA behind my report to drive
this function...
|
| =?Utf-8?B?RGF2aWQ=?= replied to Luiz Cláudio on 12 May 2004 |
Would there be a way to set this up to use a control??
|
|
Archived message: Number Pages in loop sequence (MS Access)
