vba to set 2 fields in a controlsource of a textbox

[zx3]

Hi all,

I have a table1 which contains last and first names, in a form1 i want to list all the first and last names plus the full name respectively, i just have the problem in putting together the full name (first & " " & last) with textbox's ControlSource, it returns error #names?, please help



Here is the file concerned Database1.accdb

[Bob Fitz]

The attached db does what you require but why are you using an unbound form. I have shown how to do this in frmName by concatenating the two columns in the query that the form is bound to.

[zx3]

Thanks Bob, your file helps a lot, and now i learnt a new way of doing of it other than the one i used to.

Have a nice day

[moke123]

Another trick to concatenating names or other strings is to use the law of propagating nulls.
If you had a table with a first name, middle name, last name, and a suffix you may not have one or more of those fields in each record but you want to display it if it is there. If you were to concatenate - firstname & " " & middlename & " " & lastname & " " & suffix, and you had no middle name there would be an extra space where the middle name would go.

if you use L.O.P.N. then you would write it - (firstname + " ") & (middlename + " ") & (lastname) & (" " + suffix)
Each segment of the string that are enclosed in parenthesis is evaluated separately.
A null plus anything is still null.
So if you add (+) the field to the empty space (" ") and the field is null, that segment is a null with no space.


hope this makes sense.