Extra tag data in field <div> </div>

[Dick D]

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.

 

[vbasean]

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