Issues with VBScript in Access.

[PuddinPie]

I'm not quite sure where to post this question so I'm trying here because it's always been a great resource.

I'm starting to get into Regular Expressions programming in Access. I've built a regular expression that searches for variations of PO BOX and RR but it only ever finds the first one in a string. ie. if some one has PO BOX 123 on RR 1 then it would just find the first PO BOX and the preceding RR.
I would like it to be able to find all instances of the expression.

Here's my expression:

((p[\s|\.|, ]*|post[\s|\.]*)(o[\s|\.|, ]*|office[\s|\. ]*)([box[\s|\. ]*))|(RR[\s|\.|, ]*|R.R[\s|\.]*)[/$&#'-]*

Thank you in advance.

 

[spikepl]

Do yourself and everybody a favour, and rename your post to what it is about, namely "Regular expressions to find PO BOX"

The Similar Threads at the bottom of this page is a very useful feature, but rendered useless by titles like "Help" or "pulling my hair out" or "Issue...", or, alternatively titles that completely disguise the content.

Regular Expressions is a fairly complex yet very useful subject so that's why I wrote the above.