G
Guest
I am having a problem that I see the answer to, but I don't understand what
it is that I need to do. My apologies for being a little dense.
I need to replace a string in a memo field from the string to a soft return.
In looking at posts on this, the answer seems to be to do the following:
Replace(FieldName, string, Chr(13) & Chr(10))
What I don't understand is how to do this. Do I create a button that runs
VBA code that creates a recordset and then executes this command in a loop?
Or do I create an update query that executes this code? Or do I create a
query that add this as a caclulated field? I am using Access 2003. Your
help is appreciated.
it is that I need to do. My apologies for being a little dense.
I need to replace a string in a memo field from the string to a soft return.
In looking at posts on this, the answer seems to be to do the following:
Replace(FieldName, string, Chr(13) & Chr(10))
What I don't understand is how to do this. Do I create a button that runs
VBA code that creates a recordset and then executes this command in a loop?
Or do I create an update query that executes this code? Or do I create a
query that add this as a caclulated field? I am using Access 2003. Your
help is appreciated.