Appending text to a text box on new lines
[Access 2003] I am trying to append a variable amount of lines to a text box, i am using the following approach. All the records display, however it is all on one line. Why doesnt this work?
txt_outPut.SetFocus
txt_outPut.Text = "Fabric Cost " & fabPrice
Do Until (rstRST2.EOF)
txt_outPut.Text = txt_outPut.Text & vbCrLf
txt_outPut.Text = txt_outPut.Text & rstRST2.Fields("description") & " " & rstRST2.Fields("cost")
rstRST2.MoveNext
Loop
Re: Appending text to a text box on new lines
is your textbox set to multiline?
Re: Appending text to a text box on new lines
There is no multiline property in vba is there?
Re: Appending text to a text box on new lines
excel textboxes have multiline property, so i guessed access ones would too