I have a need to create a simple find and replace word table, tblFindReplace . The table will have a FindText field and a ReplaceWith Field. This table will be used against a CompanyName text field to create a standardized Short Name value in a Client table. For example replace "First" with "1st", "Company" with "Co" etc. There are some cases inwhich the user would like to replace a value with a new value ending in one or more blanks. I have the ReplaceWith field defined as accepting a Zero length string and Required set to No. However, when one types a ReplaceWith value with one or more ending blanks, they are being retained. Is there some setting I have failed to set properly to support trailing blanks? If trailing blanks are not supported, is there a better approach than using some character to signify a blank and replacing it with a blank using code in a two pass process?