Results 1 to 3 of 3
  1. #1
    stevemig is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    3

    Rick Text Format of Text Box is replacing carriage returns in memo field with spaces.


    I have a report with a text box (using Rich Text format) with the following Control Source:
    =[Description] & "<font size=2><i>" & [code] & "</i></font>"

    Description is a memo field with carriage returns. When I preview the report, all of the carriage returns are replaced with spaces.

    Everything was fine when it was plain text, but I really need the code field in italics on the same line. I can't figure out a solution.

  2. #2
    stevemig is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    3
    Rich Text, not "Rick Text" of course. :-)
    I'm wondering if I can do something like this:
    =Replace([Description], find some character???, <br>)

    ?

  3. #3
    stevemig is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jul 2014
    Posts
    3
    I figured out the solution:
    =Replace([Description],Chr(13) & Chr(10),"<br>")

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

Similar Threads

  1. Trouble with rich text format memo field
    By lawdy in forum Access
    Replies: 10
    Last Post: 03-08-2014, 08:34 PM
  2. Replace Carriage Returns with Spaces
    By chitan in forum Queries
    Replies: 1
    Last Post: 12-15-2011, 11:14 AM
  3. Replies: 1
    Last Post: 11-05-2010, 04:31 PM
  4. Field returns error when I import Text Files to Access
    By geng in forum Import/Export Data
    Replies: 3
    Last Post: 06-01-2010, 02:20 PM
  5. Need help with Memo field text format
    By sprovoyeur in forum Access
    Replies: 1
    Last Post: 05-14-2010, 08:03 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