text box question

  • Thread starter Thread starter Brent
  • Start date Start date
B

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
 
Hi Brent,

vbCrLf will insert a line feed:

me.textbox = "text1" & vbCrLF & "text2" & vbCrLf & "text3"
 
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.
 
Back
Top