Consulting

Results 1 to 5 of 5

Thread: Wrap text in text box

  1. #1
    VBAX Regular
    Joined
    Mar 2009
    Posts
    29
    Location

    Wrap text in text box

    Hi,
    I am trying to warp text in a Text box.
    I tried this:
    TextBox1.Value = "Result:" & vbCr & 20
    But I get: Result:¶20
    Even if I use a formula and CHAR(10) I get the same result.
    I'm unable to get multiple lines in the textbox does anyone know how to work around this problem?
    Thanks
    Xrull

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    using chr(10) instead of vbcr or vblf or vbcrlf normally eliminates the funny characters. To get multiple lines in a text box, make sure you have the textbpx properties Multiline and Wordwrap both set to true.
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  3. #3
    VBAX Regular
    Joined
    Mar 2009
    Posts
    29
    Location
    MWE,
    I set the MultLine to true, and it solved my problem.
    Thanks,
    Xrull

  4. #4
    VBAX Regular
    Joined
    Mar 2009
    Posts
    29
    Location
    MWE,
    I don't see a drop down that allows me to show the post as solved.
    I only options I see it to search the thread and rate it.
    Thanks,
    Xrull

  5. #5
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    There should be a drop down called Thread Tools next to Search This Thread. If you are the original author of the thread, there should be a selection Mark Solved and an Action button below it
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the 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
  •