Query parameter

[Souris]

Dim qd As DAO.QueryDef

Set qd = EISDb.QueryDefs("MYQUERY")

qd.Parameters("pComments").Value = CStr(Replace(Me!
txtComments.Value, Chr(34), Chr(34) & Chr(34)))

qd.Execute

I have above code which failed when the comment has 874 characters and
double quotes, single quote and number sign on it.

Are there any limitations to pass paramter to a query?

Your information is great appreciated,

 

[Michel Walsh]

Number of characters for a parameter in a parameter query: 255


After all, a parameter, and a computed expression, is like a field, also
limited to 255 chars.



Vanderghast, Access MVP

 

[Souris]

Thanks for the information,

docmd.runSQL wroks.
It seems that It is better to use RunSQL for a long string to store in memo
field.

Please let me know if I am wrong,