In my form, I have FirstName and LastName fields displayed. I would like to trim the spaces and have the two fields concatenate for display purposes.
I have tried going to the field Properties in Design View, and then attempted to make an expression something like:
firstname & " " & Lastname
All that shows up where the field should be is the word Error.
I'm sure there's a way to do this that trims the leading and trailing spaces and makes the name look like I typed them together.
Help?
I have tried going to the field Properties in Design View, and then attempted to make an expression something like:
firstname & " " & Lastname
All that shows up where the field should be is the word Error.
I'm sure there's a way to do this that trims the leading and trailing spaces and makes the name look like I typed them together.
Help?