Jump to content

Access VBA Text Editing In A Report


Recommended Posts

Hey guys,

Need to know of a way to remove all text (html tags) in a field. Problem is I have no idea what tags are going to be in the fields, and they're mixed pretty well with other data I need to keep. They are standard tags in <brackets>, so I really need a replace function with RegEx support or something like that. I've got one so far and it works fine given an exact string to find and remove, but I can't account for all the various tags easily, too much effort and space. I'd post a snip of the DB and such but I work for the government and the data is semi-sensitive. I can drum up a sample though, if need be. Basically I'm just trying to purge anything between a set of <> in a normal text or memo field in Access. Appreciate any help.

Link to comment
Share on other sites


Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...