How do I Replace Paragraph Mark in an Access Field?

M

MTS

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
 
A

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
Click to expand...

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

MTS

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