Copy more than 255 characters

[Shannon88]

I have built a command button that copies 7 different fields from a form into a table. It does not work all the time because I am sometimes over the 255 characters.

I am using DoCmd.RunSQL "INSERT INTO mytable (7fields) VALUES (7fields);"

When using the DoCmc.RunSQL it only supports 255 characters. I have spend 2 hours searching and still did not find anything that will help.

Any suggestions would be much appreciated.

Thanks,

Shannon

 

[BGrego]

You should make the Field that is causing the out of bounds into a "Memo" field.

 

[Shannon88]

The one field is a memo field and I thought that was my problem but it isn't. When they say 255 characters are they talking about the data that is being copied or characters in the command line in my SQL statement?

Thanks!

 

[Shannon88]

I figured it out. I created a query off of the form into a table. It might not be the easiest way, but at least it works.

Thanks,

Shannon