Prev: Multiple "Not Like" not working
Next: How do I prevent values from been multiplied by two or three?
From: KSKFM on 22 Apr 2010 13:48
I am importing data from SharePoint list to MSACCESS. I need to strip out
html tags from the field values
From: Allen Browne on 22 Apr 2010 20:52
What version?

If you are using Access 2007 or 2010, you could use the PlainText()
function, or store the data in a RichText memo field.

Otherwise you may need to use Instr() to locate the "<" and the following
">", Len() and Mid().

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"KSKFM" <KSKFM(a)discussions.microsoft.com> wrote in message
news:DB792FBA-E17D-483F-A27E-F22E2418CE75(a)microsoft.com...
> I am importing data from SharePoint list to MSACCESS. I need to strip out
> html tags from the field values

 | 
Pages: 1
Prev: Multiple "Not Like" not working
Next: How do I prevent values from been multiplied by two or three?