Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: address in report

    I am going to create a report, There are two addresses (address1 and address2). I would like to print the address1 in one line and the address2 in the second line.
    the express: address:[Address1]&[address2].
    Can you help me? Thanks.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    the express: address:[Address1] & vbcrlf & [address2]

    izy ??
    currently using SS 2008R2

  3. #3
    Join Date
    Mar 2004
    Posts
    660
    what is the vbcrlf mean? It didn't work for me? Can you check again. Thank you.

  4. #4
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    [address] & vbnewline & [address2] or [address] & chr(13) & [address2]
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  5. #5
    Join Date
    Aug 2002
    Location
    Melbourne, Australia
    Posts
    111
    Have a look at the attached sample, it should do what you want.
    Attached Files Attached Files
    Regards,



    John A

  6. #6
    Join Date
    Mar 2004
    Posts
    660
    You are very nice. I got it work. Thank you very much!

  7. #7
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by yyu
    what is the vbcrlf mean? It didn't work for me? Can you check again. Thank you.
    Hi yyu,
    What it means simply put is: Visual Basic Carriage Return Line Feed
    Just tells VB to insert a Line at that point, all the way to the left. Sorta like the old typewriter, when you got to the end of the line the thing that moved was the Carriage. Returning it was sending it back to its original position...all the way to the left.

    Have a nice one,
    BUD

  8. #8
    Join Date
    Mar 2004
    Posts
    660
    Thank you very much! This is perfect!

Posting Permissions

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