Syntax error (comma) in query expression

[Access_Novice]

I am in query design. I am trying to put a query together and I am getting this syntax error. The error points to this field:

adjNum2: Replace([adjNum],Chr(160),"")

What is wrong with this?

[June7]

What is code 160 for - a space? Try:

adjNum2: Replace([adjNum], " ", "")

[Access_Novice]

What is code 160 for - a space? Try:

adjNum2: Replace([adjNum], " ", "")

It's a non-printing HTML character of some sort which comes from copying data from the web.

[June7]

I don't know why it errors. I just tested the Replace with Chr(160) and did not error. I copy/pasted text from a web page but I don't know if it had that non-printing character so can't tell if anything was replaced.

[Access_Novice]

I don't know why it errors. I just tested the Replace with Chr(160) and did not error. I copy/pasted text from a web page but I don't know if it had that non-printing character so can't tell if anything was replaced.

Thank you for looking into this.