how do i make infopath submit rich text items to an access databas

[Wael]

I would like some help in allowing infopath to submit forms that include
rich text boxes to an access database.

 

[Adam Harding]

hi

Not possible directly, but if you go via a web service you can submit
ANYTHING to your database from the Infopath Form. Only problem is that
databases do not recognise Rich text.

One other clever choice is to have your rich text box(outside of database) =
normal text box (in database but hidden on form) so when it submits it
submits the straight text, but on search it shows the Rich Text.

I hope this helps

Cheers Adam

Cheers Adam

 

[Brian Pembroke]

Would it be possilbe to do this with SQL Server 2000?

Thanks,
Brian

 

[Jim R]

The Access DB field you want the RTF data to enter must be a text field,
thats it...