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 figure out how to work around this.
Memo fields in Access are long data types.
Any help appreciated. Thanks.