Character Limit

[Keith]

I have a database that contains a few elements where the data type is "memo".
I have built an InfoPath form with which I had intended to populate the
database bust am unable to because of the inability of InfoPath to use long
text. Is ther any workaround for this?

 

[Adam Harding]

Hi

Two ways around this that i know of.

1. pass the form data through a web service and on to the database which
does not present any limits at all.

2. change all the fields to repeating text fields and use code in your
database to concatenate them together.

Hope this helps

Adam