AnsweredAssumed Answered

Combining First Middle Last Name using IsEmpty

Question asked by dwhylanjr on Feb 8, 2010
Latest reply on Apr 3, 2010 by LaRetta_1


Combining First Middle Last Name using IsEmpty


I am wanting to combine a person's First, Middle and Last Name into one field.  When I use the following calculation and there is no Middle Name it inserts a blank so that a name looks like this "John  Doe" instead of "John Doe".


Name_Title & " " & Name_First & " " & Name_Middle & " " & Name_Last 


I seem to recall a discussion in this forum a while back about using "IsEmpty" to remove unwanted spaces when a field is empty.  I just cannot find the discussion.


Can someone point me in the right direction or give me a sample calculation that would prevent that unwanted space when a middle name is missing?