Update TextField

[Minty]

Slight sigh...
([LastName]+",") & (" "+[FirstName]) & (" "+[MiddleInitial])

 

[SBBmaster09]

Now it is working. Thanks!

 

[Eljefegeneo]

If you want to get rid of the "," (comma) if there is only a last name try this:

=IIf(IsNull([LastName]) And IsNull([MiddleName]),[FirstName],IIf(IsNull([LastName]),[FirstName] & " " & [MiddleName],IIf(IsNull([FirstName]) And IsNull([MiddleName]),[LastName],([LastName] & "," & " " & [FirstName] & " " & [MiddleName]))))

 

[SBBmaster09]

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.