delete #'s in add1 field

R

Ray Mead

How do I remove the # symbol in the add1. For example:


611 HARRIMAN AVE S #209
#25 Apt
400 WISCONSIN ST #114
 
K

Klatuu

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.
 
Top