Paragraph marks

[Guest]

I have a field labeled Messages in my database. The way data is entered has
been switched recently, and so now data is entered via a website. I noticed
that when I ran a query on the data, the entries that have been made by the
website the data has this <P> at the beginning of each paragraph and </P> at
the end.

How do I get rid of these?

Thanks in advance for any help.

 

[Larry Linson]

I have a field labeled Messages in my database. The way data is entered has
been switched recently, and so now data is entered via a website. I
noticed
that when I ran a query on the data, the entries that have been made by
the
website the data has this <P> at the beginning of each paragraph and </P>
at
the end.

Those are the HTML markup for Paragraph beginning and ending.

Check Help for the the Replace function.

To clean the data in the Table: Use it in an Update Query, with something
like
Replace(Replace([yourdatafield],"<P>",""),"</P>","") in the Update To:
line.

Or, don't bother to clean the data, just access it via a Query with this
field defined as .
newdatafield: Replace(Replace([yourdatafield],"<P>",""),"</P>","").

For "newdatafield", substitute the Name of the Field you want to be used in
the Query for the "cleansed" data; for "yourdatafield", substitute the Name
of the Field in the Table that sometimes has the "<P>" or "</P>" added. If
the Field does not have either, it will not be affected.

Larry Linson
Microsoft Access MVP