Results 1 to 3 of 3

Thread: [RESOLVED] How to show multiple lines string using formula

  1. Mar 29th, 2008, 05:32 AM #1
    devmaneesh
    devmaneesh is offline

    Thread Starter
    Member
    Join Date
    May 2007
    Location
    Delhi
    Posts
    34

    Resolved [RESOLVED] How to show multiple lines string using formula

    Sir,

    I m trying to insert a string which is in multiple lines. Is there any keyword in CR equivalent to [vbcrlf] for showing other string to next line.

    Regards,
    Manish
    Reply With Quote Reply With Quote
  2. Mar 29th, 2008, 05:42 AM #2
    devmaneesh
    devmaneesh is offline

    Thread Starter
    Member
    Join Date
    May 2007
    Location
    Delhi
    Posts
    34

    Resolved Re: How to show multiple lines string using formula

    I got the solution. I used [chr(13)] function to enforce string to next line.
    Thanx
    Reply With Quote Reply With Quote
  3. Mar 31st, 2008, 12:32 AM #3
    VBFnewcomer
    VBFnewcomer is offline
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: [RESOLVED] How to show multiple lines string using formula

    chr(13) by itself does not perform the vbCrLf. you need to use
    Code:
    chr(10) & chr(13)
     in conjunction for proper result
    THANK YOU FOR RECOGNIZING MY CONTRIBUTION AND RATING ME!

    Working Environment
    Version: VB6
    OS: ME/XP

    Office Applications: FAQs By RobDog888 * Great Excel tutorial by si_the_geek * VB6 Errors by Si * VB6 Controls: MSFlexgrid populate by si * RichText Box Tips & Tricks * Crystal Report: Multi column Report CR9 & 11 * CR9 & 11 Group Totals * ADO related: ADO further steps * ADO Tutorial by Dee-u * DB related: SQL Reserved Words * More Reserved Words * Diff ways to Insert Records into a DB * Pictures in Database * VB6 Controls: MSFlexgrid populate by si * RichText Box Tips & Tricks * Crystal Report: Multi column Report CR9 & 11 * CR9 & 11 Group Totals * ADO related: ADO further steps * ADO Tutorial by Dee-u * DB related: SQL Reserved Words * More Reserved Words * Diff ways to Insert Records into a DB * Pictures in Database
    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