Regular Expressions with Access

[Breezwell Fab]

Hi Everyone

I am curious to know if there is some good literature or tutorials focusing on leveraging regular expressions in Access.

I am interested in providing users with the ability to search free text (or records from a database table) and simply highlight keywords and various text patterns to get started.

Thanks

[nico5038]

It's not possible to highlight words in text fields. Only a .rtf field can be used for that.

I would start with showing the users the right-click pop-up possibilities to filter and sort and when you're able to code in VBA you can use the me.filter property to store and/or manipulate the build filter.

Nic;o)

[Breezwell Fab]

Thanks for the reply.

So, how about embedding regular expressions in my SQL? Can this be done in order to provide a higher level of search control?

Thanks

[nico5038]

You can use your own user functions in the module section to enhance the query possibilities or use stringing to create a query dynamically in VBA and execute that.

Best probably to check our articles section to get an idea of the Access possibilities.

Nic;o)