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?