Two text boxes, save the first two letters of each input

[kaherdin]

Hi
I want to be able to have two text boxes on my form that firstly concatenate the values inputted and then saves this string to a field.

It's a "new record" form that generates a new record in table "tblUsers".
txtB1 & txtB2 and the text boxes would represent First Name and Last Name.

But it can't be allowed to be saved as the acctual names.

- Insead I'm looking for a way to take the first two or three letters of the name and concatenate these into one string of text and save that string to the field tblUsers.ConcatenatedName.
​

I.E.

• txtB1:"Carl"
• txtB2:"Chapelle"

would generate "CarCha" and save that from the form to the field ConcatenatedName in tblUsers.
Btw, the values form txtB1 and txtB2 (Carl & Chapelle) cant be saved anywhere either!


Found the answer myself;
create a txtB3
And set that source to Left([txtB1];3) & " " & Left([txtB2];3)

 

[pr2-eugin]

Not being sarcastic, why not just simply add CarCha to the table? Or PauFra for Paul Francis?

You can use CODE to get his manipulated by using Left function. But if you are not saving the names, so would it not be better to avoid the hassle of coding?