Need to replace some characters in my field

Palmer

New member
Local time
Today, 04:44
Joined
Jun 21, 2002
Messages
6
Hi,

One of my fields has <li> in the data. I need the <li> to be there for posting to the web, but...

I also need to make an Access report using this data minus the <li>. How do I strip it out for reporting purposes, Do I use an If statement and "if so" how do I write it...

Actually After researching the forums some more, I think I might need to replace the <li> with some type of line break or return... Is that possible?

I found some modules that deal with stripping out characters, but I don't think they will work and I am quite the novice....

Any help is greatly appreciated.

Thanks,
 
Last edited:
Thanks,
I used...
Public Function ReplaceSpace(StrRemoveSpace As String)

Let ReplaceSpace = Replace(StrRemoveSpace, "<li>", "", 1, -1, 1)

End Function

Is there a way to put in a line break or some type of return?
 

Users who are viewing this thread

Back
Top Bottom