MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

Text manipulations

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

Add brackets to a string	Add square brackets to a string (using WizHook)
Get all words as a collection	Separate all the words in a string and store them as members of a VBA Collection
Validate an email address	Validate an email address (uses RegEx)
Levenshtein Distance	Calculate a string's Levenshtein distance
Word count	Count the number of words in a string
Count occurrences	Four different ways to count the number of times a specified pattern occurs within a given string
Get or cut the nth word	Function for retrieving or cutting the nth word in a string.
Kill HTML	Function for removing HTML tags.
Reverse a string	Functions for reversing a string in a couple of different ways.
StripEx	Function for stripping out parts of a string using Regular Expressions. For example, strip all non-numeric characters, strip all space characters, and so on.
ValidateRegEx	Function for validating a value against a supplied regular expression.
NextAlphaCode	Function for incrementing an alphanumeric code.
ProperCelt	How to convert any string into its Proper Case form, including Celtic names.
Return an array from a function	How to return an array from a VBA function.
Very fast string compare	Several very fast ways to compare two strings.
Write text anywhere	API function for writing text anywhere on the screen.
SoundEx	Create a SoundEx code for a specified string
Sort an array	Sort an array's contents (uses WizHook)