Minty AWF VIP Local time Today, 08:06 Joined Jul 26, 2013 Messages 10,691 May 11, 2016 #21 Slight sigh... ([LastName]+",") & (" "+[FirstName]) & (" "+[MiddleInitial])
S SBBmaster09 Registered User. Local time Today, 15:06 Joined Apr 26, 2013 Messages 92 May 11, 2016 #22 Now it is working. Thanks!
Eljefegeneo Still trying to learn Local time Today, 00:06 Joined Jan 10, 2011 Messages 902 May 11, 2016 #23 If you want to get rid of the "," (comma) if there is only a last name try this: Code: =IIf(IsNull([LastName]) And IsNull([MiddleName]),[FirstName],IIf(IsNull([LastName]),[FirstName] & " " & [MiddleName],IIf(IsNull([FirstName]) And IsNull([MiddleName]),[LastName],([LastName] & "," & " " & [FirstName] & " " & [MiddleName]))))
If you want to get rid of the "," (comma) if there is only a last name try this: Code: =IIf(IsNull([LastName]) And IsNull([MiddleName]),[FirstName],IIf(IsNull([LastName]),[FirstName] & " " & [MiddleName],IIf(IsNull([FirstName]) And IsNull([MiddleName]),[LastName],([LastName] & "," & " " & [FirstName] & " " & [MiddleName]))))
S SBBmaster09 Registered User. Local time Today, 15:06 Joined Apr 26, 2013 Messages 92 May 11, 2016 #24 This is now SOLVED. For future reference: From the Text Box Properties of the field > Data tab > Control Source is the code below: =([txtLastName]+", ") & ([txtFirstName]+" ") & ([txtMiddleInitial]+".") Thanks so much Minty for this.
This is now SOLVED. For future reference: From the Text Box Properties of the field > Data tab > Control Source is the code below: =([txtLastName]+", ") & ([txtFirstName]+" ") & ([txtMiddleInitial]+".") Thanks so much Minty for this.