5 Replies Latest reply on Apr 3, 2010 10:44 AM by LaRetta_1

    Combining First Middle Last Name using IsEmpty



      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?