I have a report for some labels. Here is the order and control source for the fields:
=Trim([Title] & " " & [FirstName] & " " & [LastName])
JobTitle
Company
Address1
Address2
Town
County
PostalCode
If the title and names are blank then it misses out the jobtitle. How can I fix this? if the names and title are there then it doesn't miss out any fields. Thanks.