Unable to replace return/newline characters in Access but works in Excel

[jimmy2]

Hi Guys ,

I have the below code which i place in my make table design view and ideally is meant to remove all return and "Enter" Keys in access as well as newline

Replace([myfield]," " & Chr(10) & " " & Chr(13),"")

this doesnt seem to be doing the job but if i coppy the same row in excel it works fine even by using the ALT+0010.

Can you kindly advise me where im going wrong

 

[SydneyGeek]

Do you actually have the space between the CR and LF characters? Try...

Replace([myfield]," " & Chr(10) & Chr(13),"")

Denis

 

[jimmy2]

Do you actually have the space between the CR and LF characters? Try...

Replace([myfield]," " & Chr(10) & Chr(13),"")

Denis

Sooorry bout the late reply...

It something im never sure of as users just enter data randomly including these keys.

The workaround is running this in Excel as it works perfectly but when u have to re-write 50 queries then u know u not clever