Hi,
I have a form with a text box called notes(using memo field type, since it'll be more than 255 field size), so users can enter whatever notes or complaints for a specific products. The problem now is when I clicked the save button for the form, it'll give me an error message saying "the parameter values are too large, parameter can't exceed 1024 characters" the save button cmd that I used is
DoCmd.runSQL "INSERT INTO tblcomplaint (JobID,notes) VALUES(Forms!compaint!txtJObID,Forms!complaint!txt notes)"
Is it because I used insert query to save notes? any other idea on how to save more than 1024 character notes to a table? please help. As you can see, I'm very new to access. Thank you