Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display some information on all the pages of a document except on the Cover page.

I have a variable in my macro that return an identification number for each document. I would like this information to be on every page except the cover page.

what coding would I have to use? the IIF function?

Daniel
 
You may be able to use Page. If Page=1, don't show your item. This may be
done using an IIf statement in the control or in the Format event of the
report section.

Example:
=IIf([Page]=1, "", "Print This")
or
=IIf([Page]=1, "", [Field1])

--
Wayne Morgan
Microsoft Access MVP


Daniel P said:
I want to display some information on all the pages of a document except on the Cover page.

I have a variable in my macro that return an identification number for
Click to expand...
each document. I would like this information to be on every page except the
cover page.
 
Itried your code as follows

Me.Label173.Caption = IIf([Page] = 1, "", "EPS-" & EPSNum & "-" & EPSRev

where EPSNum and EPS Rev are known variables, but it shows up on all the pages including the cover (page 1)

Daniel
 
Ok, the example was intended as a control source for a calculated textbox.
For a label and doing this in VBA try

If Page=1 Then
Me.Label173.Visible=False
Else
Me.Label173.Visible=True
Me.Label173.Caption="EPS-" & EPSNum & "-" & EPSRev
End If

--
Wayne Morgan
Microsoft Access MVP


Daniel P said:
Itried your code as follows:

Me.Label173.Caption = IIf([Page] = 1, "", "EPS-" & EPSNum & "-" & EPSRev)

where EPSNum and EPS Rev are known variables, but it shows up on all the
Click to expand...
pages including the cover (page 1).
 
Wayne

it still shows up on all the pages of my report!?

I've added your code in the Private Sub Report_Open(Cancel As Integer) section of my VBA code, could this be a problem? Should it be elsewhere?
 
Try the code in the Format event of the section that contains the control in
question.

--
Wayne Morgan
Microsoft Access MVP


Daniel P said:
Wayne,

it still shows up on all the pages of my report!?

I've added your code in the Private Sub Report_Open(Cancel As Integer)
Click to expand...
section of my VBA code, could this be a problem? Should it be elsewhere?
 
Back
Top