defaulting to field(s) w/ data (1 Viewer)

[lscheer]

I have a Labels report in which I want to display two fields (two different contact names), however, I only want the second field to be displayed if there is no data in the first field, and then suppress whichever field is not displayed. Is this possible???

 

[Chris RR]

Instead of printing either contact1 or contact2, in the Control Source, put something like this:

=IIf(Isnull(Contact1)),Contact2,Contact1)

This says that if Contact1 is null, use Contact2, otherwise use Contact1.