InfoPath Dev

I have an InfoPath form that submits data to an Access database. I need to be able to write more than 255 characters into the text box fields and store this information into Access. Any ideas on how to accomplish this? I get error messages that Infopath will not support long data types and Access text fields are limited to 255 characters. I can't ...

Thanks for the reply but I don't think I can increase the size of the text filed in Access. Here's the issue I am dealing with. Access limits text fields to 255 characters. It's my understanding if you want to input more than 255 characters into a filed you must use a Memo field. InfoPath does not support long data types and Memo fields are ...

I have an InfoPath form that submits data to an Access database. I need to be able to write more than 255 characters into the text box fields and store this information into Access. Any ideas on how to accomplish this? I get error messages that Infopath will not support long data types and Access text fields are limited to 255 characters. I can't ...