In Access what code would remove brackets/dashes in fax field

[Juliet]

I need to strip the dashes and brackets from my fax field for our server to
fax automatically and I am looking for the code for that.

 

[John Spencer]

Try the replace function if you are using versions of Access after 97.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Juliet]

Thanks John! that worked perfectly!!!!

Try the replace function if you are using versions of Access after 97.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..