Remove " " marks from a text string 1

[DannyBill]

I have a field that currently has data "123456", I'm trying to figure out how to remove the " " marks so that it's 123456.

Any help would be greatly appreciated

Thanks in advance.....

 

[SgtJarrow]

Perhaps Replace(value, """", "") ????

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[DannyBill]

ok...I tried this....Replace ( [Macid1]![city] ," " ", " " ) and it says the second comma is an invalid syntax

 

[SgtJarrow]

To get at the double quotes....you have to put two double quotes inside the double quotes. Escape characters/formatting requirements.

So: Replace([Macid1]![city] , """", "")

And you probably do not want the extra space in the third parameter....otherwise you end up with ^12345^ where ^ is a space character.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[DannyBill]

that worked....thank you..... It's amazing how something so simple can be so frustrating when you're new to all this.

Thanks again.

 

[PHV]

Another way:
Replace([Macid1]![city] , Chr(34), "")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SgtJarrow]

Thanks PHV. I always forget about the chr function when using Replace.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer