Extra tag data in field div /div

I imported a sharepoint list and created forms for data entry (Access 2007)
In two fields, I am getting my data bracketed with div and /div tags.
These were memo fields in sharepoint.

How can I stop this from continuing?

Thank you for your help.

You'll have to scrub that field everytime you retreave/import it.

You can create an update query that scrubs those tags but you'll have to run
it every time you import. Where the criteria is something like:
Like "div*/div"
Updating to something like:
Mid([your memo field],6,Len([your memo field]) - 11)

otherwise you'd have to create a custom data import with this type of logic
in it. That's another ball of wax.
You can
--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"Dick D" wrote:

I imported a sharepoint list and created forms for data entry (Access 2007)
In two fields, I am getting my data bracketed with div and /div tags.
These were memo fields in sharepoint.

How can I stop this from continuing?

Thank you for your help.