Results 1 to 3 of 3
  1. 11-01-2009, 10:41 PM #1
    DanW
    DanW is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    30

    Text string formatting

    I cannot remember enough to make it work again. I want to have a memo box with paragraphs of different text boxes.

    I think it was like Me!txtMemo = Me!txtA & Chr34 & Chr10 & Me!txtB & Chr34 & Chr10 & Me!txtC

    I think I have the wrong character numbers. What is the right coding for that?
    Reply With Quote Reply With Quote
  2. 11-02-2009, 05:10 AM #2
    dcrake's Avatar
    dcrake
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    You can concat them with either vbNewline or VbCrLf

    David
    Reply With Quote Reply With Quote
  3. 11-02-2009, 11:11 AM #3
    DanW
    DanW is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2009
    Posts
    30
    Thank you very much,
    Dan
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Auto Formatting Text in a Form
    By swicklund in forum Access
    Replies: 0
    Last Post: 07-23-2009, 01:15 PM
  2. Conditional formatting
    By ylivne in forum Reports
    Replies: 1
    Last Post: 07-12-2009, 06:18 PM
  3. Export Formatting
    By arthura in forum Import/Export Data
    Replies: 0
    Last Post: 02-20-2009, 08:44 AM
  4. Extract numbers from text string strored in a field.
    By khabdullah in forum Programming
    Replies: 2
    Last Post: 12-23-2007, 06:55 PM
  5. Need Help Formatting a field.
    By marshallgrads in forum Access
    Replies: 4
    Last Post: 12-06-2007, 03:44 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums