G
Guest
HELP!
I am trying to insert the value of a text box on a form into a memo field in
a table. I'm using DoCmd.RunSQL INSERT INTO method to get this accomplished.
The whole thing works fine as long as the value in the text box is less than
128 characters. Since it is a memo field in the table, I don't understand
why the length of the text box makes any difference. The code runs fine
unless the text in the text box is longer than 128 characters. Any ideas?
Here's my code (but like I stated, it runs fine unless the text in the text
box is longer than 128 characters):
DoCmd.RunSQL "INSERT INTO HRC ([CLNO],[RESTRICTIVE MEASURE]," & _
"[DESC],[CAUSER],[HRC Expiration],[IsConsentReq]) VALUES (" & _
"Forms!FrmHRCAffectedByOthers!CLNO," & _
"Forms!FrmHRCAffectedByOthers!Text33," & _
"Forms!FrmHRCAffectedByOthers!Text35," & _
"Forms!FrmHRCAffectedByOthers!Text31," & _
"Forms!FrmHRCAffectedByOthers!Text37," & _
"Forms!FrmHRCAffectedByOthers!Check38)"
I am trying to insert the value of a text box on a form into a memo field in
a table. I'm using DoCmd.RunSQL INSERT INTO method to get this accomplished.
The whole thing works fine as long as the value in the text box is less than
128 characters. Since it is a memo field in the table, I don't understand
why the length of the text box makes any difference. The code runs fine
unless the text in the text box is longer than 128 characters. Any ideas?
Here's my code (but like I stated, it runs fine unless the text in the text
box is longer than 128 characters):
DoCmd.RunSQL "INSERT INTO HRC ([CLNO],[RESTRICTIVE MEASURE]," & _
"[DESC],[CAUSER],[HRC Expiration],[IsConsentReq]) VALUES (" & _
"Forms!FrmHRCAffectedByOthers!CLNO," & _
"Forms!FrmHRCAffectedByOthers!Text33," & _
"Forms!FrmHRCAffectedByOthers!Text35," & _
"Forms!FrmHRCAffectedByOthers!Text31," & _
"Forms!FrmHRCAffectedByOthers!Text37," & _
"Forms!FrmHRCAffectedByOthers!Check38)"