How to break lines in memo fields?

[newyorkyankee]

Hello,

in my table there's a memo field containing the description of an object, e.g.: red, old, american, powerful, classic, still produced, big.

How do I insert a new line after every comma so the memo field looks like a list, e.g.:

red,
old,
american,
powerful,
classic,
still produced,
big



And if I wanted to erase the comma and then break the line? Or break the line before an opening parenthesis?

I could do it manually but there are thousands of records.

Thanks!

[orange]

A memo field is much like the "old shoebox" for photos. You just pitch the photos in the box. Very simple.
Now if storing the photos was the only issue, issue solved!.
However, it is quite typical to want to retrieve photos for different purposes or occasions. Now it's a little trickier.
Reach in, get a good handful of photos, review each (turn 'em over to see if anyone had the foresight to write a date on it, or even identify some of those kids/friends/relatives we knew so well at the time). Next handful, and then another. This is quite similar to the memo field - stores lots of data, can't be indexed or easily manipulated, but real easy just to dump things in.
However, getting things out, especially formatted, is now problematic. It's like storing html, you can store it, but it doesn't format until each of the controls gets rendered.
The best tools for formatting are probably word processors, but then you'd have to embed the proper control characters in order fro the word -processor to render the final output as you intended.

All this to say and highlight, that if you want to get something out of your database (or shoebox) in some predetermined formats, the best time to consider these facts is at design time. If you know what you want out, you can design/develop/create processes to ensure it happens (maybe).

Perhaps things have changed in 2007 or 2010, with rich text etc, but I have 2003 and have no simple method of bolding and formatting memo fields easily. Memo fields are much like shoeboxes from my experience.

I did google and found this (not a solution but other user experiences)
http://social.msdn.microsoft.com/For...8-863b378d548c

This may be useful.
http://www.techrepublic.com/blog/mso...-and-2010/4795

[June7]

You are saving multiple distinct values into one field - bad design. If you ever want to search/sort by say color, how would you do that? If these are standard categories of data (color, age origin, etc), have a field for each.

If you still want the memo field, try setting the Enter Key Behavior property of the textbox to 'New line in field'.