Help! I'm trying to replace all the "&" symbols in a field in a table. I was going to try using replace in my VB code, but everytime I do this it delete all the information in the field. As I don't know where abouts in the data the "&" symbol will appear I can't use anything that requires length information.
The & (and other special characters) can be a royal PITA to deal with. The ampersand in Accees can indicate both a Long data type and concantenation. My suggestion is to some code like I have in this post: http://www.dbforums.com/t926445.html and the compare value is using the CHR(38) to represent the ampersand.