Combining 3 text boxes

[ielmrani via AccessMonster.com]

Hi,
This sounds simple but it's not working for me.
I have a form with 3 text boxes.
Text1 = John Lerch
Text2 = Joe Lerch
Text3 = Jim Lerch

i want to put all three names in one text box Like this:

Text4 = John Lerch Joe Lerch Jim Lerch

I know how to do this in a query: [Text1] & " " & [Text2] & " " &[Text3]

How do I do this in VBA.

Thanks in advance.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200802/1

[boblarson]

Me.Text4 = Me.Text1 & " " & Me.Text2 & " " & Me.Text3
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

[ielmrani via AccessMonster.com]

Thank you for your quick reply. It worked

boblarson wrote:
>Me.Text4 = Me.Text1 & " " & Me.Text2 & " " & Me.Text3

>> Hi,
>> This sounds simple but it's not working for me.

>[quoted text clipped - 12 lines]