Text Dilemna

I am currently creating a module in an access database. The Module sends out a long text string. The text is so long that it doesnt fit into one line alone(there is no more space). I wanted to know how I could continue this text to the next line. EX: stringtxt= "dsadfdsasd (then i cant go on becasue there is not more space). How do I continue the text on to the next line?

Hello Nadoo8989,

You can use line continue _ operator and use the & operator to force string concatenation. Hope it will help. EX:

stringtxt = "abcd" & _
"efgh"

Try this: stringtxt = "some really long text in here but we can continue it using the underscore character" _
& "we closed out the first part of the text, added the underscore to show that the line continues " _
& "then used the & symbol to concatinate the rest of the line in."


Note that there is a limit to the number of continuation lines in VB 6. I don't know for sure if that applies to VBA.

I hope this helps...