Combining 3 text boxes

  • Thread starter Thread starter ielmrani via AccessMonster.com
  • Start date Start date
I

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.
 
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.
__________________________________
 
Back
Top