text box question

[Brent]

I have some code that is combining information contained in a table and
putting it in a text box.
Example.
text1,text2,text3

today I am separating this information with a comma. Is there a way to add
a line between these values instead? The reason I'm doing this is because
my form is already opening as continuous form so using a subform is not an
option. Any help is appreciated.

Proposed Example
Text1

Text2

Text3

 

[SusanV]

Hi Brent,

vbCrLf will insert a line feed:

me.textbox = "text1" & vbCrLF & "text2" & vbCrLf & "text3"

 

[Bill Edwards]

So, why is using a subform not an option?

You can have subforms with continuous forms. Put the subform in the form
footer section of the continuous form.
Another option would be to create a main form; create a continuous form;
create the subform. Place the continuous form and subform inside the main
form as subforms and then link them.

 

[Brent]

Thanks....works great!!

Hi Brent,

vbCrLf will insert a line feed:

me.textbox = "text1" & vbCrLF & "text2" & vbCrLf & "text3"

 

[SusanV]

Glad to help!

;-D

Thanks....works great!!