Conditional Printing of Multiple fields

  • Thread starter Thread starter jake
  • Start date Start date
J

jake

I'm writing a report for Social Security - in it we must list a
Survivor Name, address, city, zip and phone number. This info is only
printed if the survior relationship is that of a "Spouse" -

How do I go about getting all these field to print (Relationship =
Spouse) or to be blank for all other situations.

Your help is greatly appreciated!
Jake
 
Jake:

Use the On Print Event of the detail section of the report with code like
this:

If Me!Relationship = "Spouse" Then '(or some relationship type ID)
Me!SurvivorName.Visible = True
'add other related fields
Else
Me!SurvivorName.Visible = False
'add other related fields
End if

HTH
 
Back
Top