Conditional Printing of Multiple fields

[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

 

[SA]

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