i cannot input more than 255 words in my form

[jason ashby]

I have a form in info path connected to a data base but i can only put 255
words in a text box. i have changed the database data type to memo but it
will not enable it.

 

[Scott L. Heim [MSFT]]

Hi Jason,

You will be unable to directly bind an InfoPath control to a field in an
Access database where the data type is "Memo." If you truly need this much
space to enter text, you have a few options:

- Use multiple fields in the database and hence multiple fields on your
InfoPath form to enter the data
- Create a web service that retrieves/updates the data from your Access
database and then bind your InfoPath solution to the web service instead of
the Access database

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Keith]

Hi Scott

Just how does one go about "Create a web service that retrieves/updates the
data from your Access database and then bind your InfoPath solution to the
web service instead of the Access database"

Keith