How to concatenate strings in vba

[Sherianmartin]

I am trying to concatenate several sentences stored in textboxes into one textbox. I tried creating a Query and creating the new field to store the data. then use the & to combine the sentences. However, that doesn't seem to work. Any help will be appreciated.

[twinnyfo]

Sherianmartin,

You have not told us what it is about this code that does not work. I know that it will not work if you try to debug it because things are out of order and you have subs and functions intermingled improperly. Also, it is clearly not designed to merely concatenate three sentences into one.

I wouldn't begin to troubleshoot this code, as you have not attempted a solution yourself. Please keep in mind, that this is not intended as a slight. However, on these forums, we expect our posters to have put in the required effort to try to solve their problems first, and then seek advice for specific problems that those of us with greater experience may be able to assist with.

To be honest, the solution to your initial question is incredibly simple. However, the code you posted is incredibly over-complexified, and doesn't address your question.

[Sherianmartin]

Thanks for your reply. However, if I knew the answer or how to accomplish this I wouldn't be using your site. Someday I will become an expert like yourself, but I wouldn't mind helping others!

[Sherianmartin]

I am trying to concatenate several sentences stored in textboxes into one textbox. I tried creating a Query and creating the new field to store the data. then use the & to combine the sentences. However, that doesn't seem to work. Any help will be appreciated.

[twinnyfo]

Sherian,

If you browse this site, you will see that I help quite a few people on a daily basis.

However, in your original post, you say you are

trying to concatenate several sentences into one text box.

If you know how to concatenate (that is, if you know enough to know what the word concatenate means), then you essentially have your answer. But, again, you have not even demonstrated an attempt at solving the problem.

However, if you truly have no idea what concatenation is, this should point you in the right direction:

TextBox = String1 & " and " & String2 & " and " & string3

Let me know if that helps at all.