return break after each sentence in a memo field (1 Viewer)

[socko139]

Is it possible to write code to force a return break every time you have a new sentence in a memo field. The way Access does it is every time you have a new sentence it follows the previous sentence. I want to clean up my database and provide a return break every time there is a new sentence. Any suggestions???

Thanks so much.

 

[Rich@ITTC]

Hi Socko139

Do you want to add a line break to existing data or do you want the Memo field to respect end of sentences/line breaks for data that users will be entering.

Have a look at this link - some of the suggestions may help.
http://www.access-programmers.co.uk/ubb/Forum4/HTML/002415.html

HTH

Rich Gorvin