Hello
Trying to update a memo field in an update query using the Replace
function, and am getting a type conversion error. Here is my parameter:
CStr(Replace(CStr([text1]),"$",Chr$(13) & Chr$(10)))
This fails. However, this also fails:
CStr([text1])
I have tried to set the query parameters for the Text1 field, but when
I run it, it asks me for the value of the field.