How do I Replace Paragraph Mark in an Access Field?

[Guest]

How do I replace a Paragraph Mark in an Access Field - In Word you can do
this with ^p as a Special Character. Also need to do the reverse, replace
selected marker with a Paragraph Mark
All help extremely gratefully appreciated

 

[Andi Mayer]

How do I replace a Paragraph Mark in an Access Field - In Word you can do
this with ^p as a Special Character. Also need to do the reverse, replace
selected marker with a Paragraph Mark
All help extremely gratefully appreciated

you don't have paragraphs in Access
if you mean a "new Line" then it CHr(13)&chr(10) or vbCrLf

 

[Guest]

THank you - this is wonderful to have somewhere to get such prompt an
relevant help. Apologies for delay in getting back to you

 

[Guest]

I'm having the same trouble. How did you replace the line space?

Thanks.