Combining 3 text boxes

  • Thread starter ielmrani via AccessMonster.com
  • 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.
 
B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top