Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I make a report display onl
- Thread starter kutibo
- Start date
Use the 'on format' event of the report or page header
Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
if [accountnumber] = 387 or [accountnumber]= 390 then
me.accountheader.visible = true
me.buildingheader.visible = false
else
me.accountheader.visible = false
me.buildingheader.visible = true
End Sub
Mike Rohde
rohdem@marshallengines.com
Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
if [accountnumber] = 387 or [accountnumber]= 390 then
me.accountheader.visible = true
me.buildingheader.visible = false
else
me.accountheader.visible = false
me.buildingheader.visible = true
End Sub
Mike Rohde
rohdem@marshallengines.com
- Status
Similar threads
- Locked
- Question
