Line Breaks in Memo Field

[LadyDi]

I have a memo field on my form that was imported from other software where a service tech enters the details of what he or she did on a call. The way that field is formatted in the source file, is that it uses ^ instead of line breaks. As a result, when that field is imported in to Access for analysis purposes, it is difficult to read because the text all runs together and has ^ every so often. Is there a way to format that field on my form so that Access will replace every ^ with a line break?

For example, the text imported into the database would like like this: Arrived on site^found unit unplugged^plugged back in ^worked fine.
I would like this text to show this way on my form:
Arrived on site
found unit unplugged
plugged back in
worked fine.

Is that possible? Any assistance you can provide would be greatly appreciated.

 

[mdlueck]

I would suggest you use VBA code to search/replace in the memo field string, search for the "^" character and replace with the vbCrLf constant which means the desired function on the Windows platform.

This should work in your case...

Replace (strMemoFieldValue, "^", vbCrLf)

which will return the cleaned up string to be stored in the table.

 

[LadyDi]

That worked perfectly. Thank you very much.

 

[mdlueck]

You are most welcome, LadyDi!