Results 1 to 3 of 3
  1. #1
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172

    Is there a limit to the number of new lines you can force using vba?

    Hi,

    I am generating an e-mail through vba, and am having an issue with forcing new lines.

    I have tried using both Chr(13) and vbNewLine to force new lines in my e-mail, but with both methods, lines 1-7 are on separate lines, however lines 8,9 & 10 are all on the same line.



    Does anyone have any experience with this?

    Thanks,

    Kirsti

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    It would help to see the code. You can certainly have more lines than that.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172
    Thanks Paul,

    After googling and finding other people had the same issue for no apparent reason, I ended up just adding a 2nd vbNewLine, which worked (giving me an additional carriage return). Seems strange, but the resulting e-mail does what I need it to.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-01-2012, 03:59 PM
  2. Replies: 0
    Last Post: 12-06-2011, 05:53 AM
  3. Limit number of records in report
    By aksnell in forum Reports
    Replies: 3
    Last Post: 12-05-2011, 02:31 PM
  4. Replies: 5
    Last Post: 12-26-2010, 10:56 PM
  5. Limit number of records in report by group
    By Dr Ennui in forum Reports
    Replies: 0
    Last Post: 06-22-2010, 12:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums