Results 1 to 4 of 4

Thread: Appending text to a text box on new lines

Threaded View

  1. Jul 12th, 2009, 04:52 PM #1
    mexaros
    mexaros is offline

    Thread Starter
    New Member
    Join Date
    Jul 2009
    Posts
    2

    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
    Last edited by mexaros; Jul 12th, 2009 at 05:03 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width