Results 1 to 5 of 5

Thread: Textbox Multiline

  1. Feb 3rd, 2005, 04:10 AM #1
    haihems
    haihems is offline

    Thread Starter
    Addicted Member haihems's Avatar
    Join Date
    Oct 2004
    Posts
    150

    Textbox Multiline

    Hi,

    I get some huge text from a cell in Excel to the Textbox in my form, which is set to Multiline and have scrollbars. The problem is I couldn't get the exact format of the text --> meaning, the spaces between the lines. In Excel, I'm having the list of lines with numbers 1,2,3...But when it retrieved from Excel, Textbox shows it as a paragraph. How can I format the Text???

    Regrads,
    Hems.
    Reply With Quote Reply With Quote
  2. Feb 3rd, 2005, 04:18 AM #2
    Lil Ms Squirrel
    Lil Ms Squirrel is offline
    Hyperactive Member Lil Ms Squirrel's Avatar
    Join Date
    Nov 2004
    Location
    planet squirrel
    Posts
    494

    Re: Textbox Multiline

    Have you tried using the RichTextBox control?

    This allows you to format text so should hopefully solve your problem.
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
    Dr. Seuss
    Reply With Quote Reply With Quote
  3. Feb 3rd, 2005, 04:28 AM #3
    haihems
    haihems is offline

    Thread Starter
    Addicted Member haihems's Avatar
    Join Date
    Oct 2004
    Posts
    150

    Re: Textbox Multiline

    hi,

    But the text in the Excel is entered by the user. So I don't know where it have the spaces between the lines and all. So how can i get & store what exactly the user types??
    Reply With Quote Reply With Quote
  4. Feb 3rd, 2005, 05:00 AM #4
    wossname
    wossname is offline
    type Woss is new Grumpy; wossname's Avatar
    Join Date
    Aug 2002
    Location
    #!/bin/bash
    Posts
    5,682

    Re: Textbox Multiline

    Quote Originally Posted by haihems
    hi,

    But the text in the Excel is entered by the user. So I don't know where it have the spaces between the lines and all. So how can i get & store what exactly the user types??
    You can't, because Excel applies its own formating rules to the user input.
    I don't live here any more.
    Reply With Quote Reply With Quote
  6. Feb 3rd, 2005, 07:27 AM #5
    taxes
    taxes is offline
    PowerPoster
    Join Date
    Dec 2003
    Location
    Bristol, England (but heart is in Virginia)
    Posts
    2,949

    Re: Textbox Multiline

    Hi wossname,

    Can't he import the text and then do a split on VBCRLF?
    Taxes
    The more I learn about VB.NET the more I like dBaseIII Plus

    The foregoing, whilst believed to be correct, is given without guarantee as to it's accuracy and entirely without recourse. You are required to decide for yourself whether or not it is suitable for your purposes and no liability for loss of any nature can be entertained.
    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