Labels

[Lyncroft]

Been tearing my hair out on this one. To cut a long story short and for reasons too complicated (and frustrating) to explain some of my labels hold the same information on 2 lines.

The two lines are
=Trim([Report]![Name]
=Trim([Organisation])

If they are the same I don't want the first line to appear. Is this possible?

 

[MrRobin]

In place of the first line, place a text box containing the following:

=IIF(([Report]![Name])=([Organisation]),"",([Report]![Name]))

This will result in a blank line appearing should the Name match the Organisation, hope this helps.

Robin

 

[Lyncroft]

Mr Robin - fantastic. You have no idea how much trouble I've had with this.

Cheers