Paragraph marks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

trainsteve - 19 Jul 2007 22:10 GMT

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 at the beginning of each paragraph and at
the end.

How do I get rid of these?

Thanks in advance for any help.

Reply to this Message

Larry Linson - 21 Jul 2007 06:11 GMT

>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
[quoted text clipped - 4 lines]
> 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],"",""),"","") 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],"",""),"","").

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 "" or "" added. If
the Field does not have either, it will not be affected.

Larry Linson
Microsoft Access MVP

Reply to this Message