This is my formula to display the Full Name. My issue is that if there is only say a first name and a last name the full name has an extra space in it (Jim space space Jones), I am looking for a way to correct this without using an IIf clause for each argument and building a long involved formula. I am not sure if this is possible, I thought using the Trim would be sufficient but it is not.
Code:
FullName: Trim([Prefix] & " " & [FirstName] & " " & [MiddleName] & " " & [LastName] & " " & [Suffix])
Jim O