Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a field, which is a memo field. It contains comments of each record. However the user has been hitting return to go to a new line, hence creating wasted storage and difficulty to export in a query.

    Any ideas how I overcome the problem. Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='ZOR' post='764779' date='11-Mar-2009 11:53'][/quote]
    If you want to replace the carriage returns by spaces then use in an update query :
    Replace([Yourmemofield],Chr(13) & Chr(10)," ")
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks Francois. I will give it a try. Regards

  4. #4
    4 Star Lounger
    Join Date
    Feb 2008
    Location
    United Kingdom
    Posts
    490
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I did a query, it warned of table violations etc, but I hit the button and it did the job perfectly, so thanks again.

  5. #5
    New Lounger
    Join Date
    Dec 2008
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Was a great help to me too!

    Much Thanks,

    TexasTJ

Posting Permissions

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