delete #'s in add1 field

's Computer Specifications

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

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

's Computer Specifications

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.

"Ray Mead" wrote:

> How do I remove the # symbol in the add1. For example:
>
>
> 611 HARRIMAN AVE S #209
> #25 Apt
> 400 WISCONSIN ST #114

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete a field value?	lvensen	Microsoft Access	2	1st Oct 2009 07:27 PM
How do I delete data in a field in Access but not delete the whol.	=?Utf-8?B?TGVhbm5l?=	Microsoft Access Queries	1	5th Mar 2005 10:27 PM
Can't Delete Field	Kevin Sprinkel	Microsoft Access	4	20th Jan 2004 01:55 PM
Delete all records matching a field except for one based on an includeddate field	naniboujou	Microsoft Access Queries	3	13th Dec 2003 03:31 AM
Can't delete a field	Tony Williams	Microsoft Access Forms	1	1st Oct 2003 01:39 PM