Access 2010 Code Example: Performing Tokenized Replacements in a String
The Replace function in VBA makes it easy to create code that replaces numbered placeholders in a string with ordered values from a list. The VBA example in this download accompanies the article "Performing Tokenized Replacements in a String in Access 2010."