G Guest Jun 23, 2005 #1 How do I remove the # symbol in the add1. For example: 611 HARRIMAN AVE S #209 #25 Apt 400 WISCONSIN ST #114
How do I remove the # symbol in the add1. For example: 611 HARRIMAN AVE S #209 #25 Apt 400 WISCONSIN ST #114
G Guest Jun 23, 2005 #2 strAddr = "611 HARRIMAN AVE S #209" strAddr= Replace(strAddr,"#","") This will work regardless of the number of # in the string. See Access Help for more info on the Replace() Function.
strAddr = "611 HARRIMAN AVE S #209" strAddr= Replace(strAddr,"#","") This will work regardless of the number of # in the string. See Access Help for more info on the Replace() Function.
