The Replace function built into VBA makes it easy to create a replacement system in which the code replaces numbered placeholders in a string with ordered values from a list. The VBA example in this download accompanies the Visual How To article Performing Tokenized Replacements in a String in Access 2010. 

This download works with the following Office applications:

To install this download:

  1. Download the file by clicking the Download link (above) and saving the file to your hard drive.
  2. Double-click the AccessTokenizedReplacement_CODE.zip file on your hard disk drive to extract the file named AccessTokenizedReplacement.accdb.