Hi all,

I’m having a spot of trouble with a InfoPath form I am working on.

First, ill give some background info of what I’m trying to do.

What this form does, is retrieve data from various sources (mainly
SharePoint and SQL server) and displays the info all nice and neatly on the
InfoPath form.

The Data is read out of a database and into a rich text field (with some
script to copy the data from the source to the control). This works fine.

However, with saving, the issue lies.

When I save 90% of my records, they save fine, no issues, no stray html, all
is fine.

However the remaining 10% return with some funkiness.

On some records I get the following error:

"You have error A string literal was expected, but no opening quote
character was found."

and for whatever reason I cannot find what is causing this error.

On other records, the text saves fine, however, when i go back into the form
and load up their data, the following appears

Geological and geophysical studies and PPL application documentation for
Dorodillo, Muscat, Keena, Wirrarie/Caladan, Wooloo, Shiraz, Kirralee,
Atreides, Grenache, Waukatanna, Touriga and Trebbiano fields, including HIP
review
5) Member of Technical Limit Team, Nov. 2000-May 2001
G&G representative team commissioned to improve spud to online time for SABU
development wells
<div xmlns='http://www.w3.org/1999/xhtml'> </div> <div
xmlns='http://www.w3.org/1999/xhtml'>6) Member of TeamLink Peer Assist
Team</div> <div xmlns='http://www.w3.org/1999/xhtml'> </div> <div
xmlns="http://www.w3.org/1999/xhtml">Pre-Santos experience:</div> <div
xmlns="http://www.w3.org/1999/xhtml"> </div> <div
xmlns="http://www.w3.org/1999/xhtml">1) 1990-1998 Chevron Europe:</div> <div

note: I cut this timed from the start ad end for this post. Also note that
this is not the source of the text box, this is what is actually displayed IN
the textbox as plain text.

If needs be I can post the data which I use and anything else required. This
is a real tricky one and I’m going bald with stress and ripping out my hair
trying to figure out what is the problem.

Any help would be greatly appreciated!

Regards,

Daniel Brown