A
abc
I have an access backend containing memo data types. I know infopath
does not support memo data types.
Is there a way around this?
does not support memo data types.
Is there a way around this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Scott L. Heim [MSFT]
Hi,
There are a couple of options:
- Do you truly need the "Memo" data type? If not, change these to text
fields.
- If you do need the "Memo" data type then you can use a web service to
retrieve and update your data and then simply bind your InfoPath form to
the web service instead of directly to 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.
There are a couple of options:
- Do you truly need the "Memo" data type? If not, change these to text
fields.
- If you do need the "Memo" data type then you can use a web service to
retrieve and update your data and then simply bind your InfoPath form to
the web service instead of directly to 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.
A
abc
Unfortunately, I cannot use a web service.. is there any other way?
Maybe finding a way to break up the memo fields into text fields
(Access)??
Maybe finding a way to break up the memo fields into text fields
(Access)??
S
Scott L. Heim [MSFT]
Hi,
Yes - that was part of my previous suggestion: if you simply need the
ability to enter more than 255 characters, then you could possible create
multiple text fields in Access to replace the one memo field; however, this
could get cumbersome if you wind up needed an excessive number of fields.
Other than this, the only other option I know of is to use a web service.
Best Regards,
Scott L. Heim
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Yes - that was part of my previous suggestion: if you simply need the
ability to enter more than 255 characters, then you could possible create
multiple text fields in Access to replace the one memo field; however, this
could get cumbersome if you wind up needed an excessive number of fields.
Other than this, the only other option I know of is to use a web service.
Best Regards,
Scott L. Heim
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.