Change a plain text field into a Rich Text field without loosing data

I call it the Ikea moment. It's when you are almost done building and you realize that you've put something in backwards, and as a result you're going to have to redo the entire thing.

I seem to have an ikea moment with my infopath form. I had to update a template that our students use for doing writing activities.  There was a problem with content types on the sharepoint folder in which they are stored, so it seemed like the easiest way to do it would be to start from scratch. Unfortunately, when I tried to link the new template to the old files, none of the data showed up.

I had just finished spending the last two days recreating all the forms in the new template when I realized that one of the fields was set as text(string) or plaintext, when it should have been rich text. Doh!

I did a little searching and found that the way to accomplish this would be to edit the myschema.xsd file, but i can't seem to get it to work properly. I'm hoping that someone who knows xml better than me can help out here.

The post I found, (here: http://www.omgili.com/newsgroups/microsoft/public/infopath/5597EE8D-24D9-467B-A52D-B535D686B59Dmicrosoftcom.html&q=rich+text) suggests changing the xsd:element tag for the field in question. In my form, however; the "Work" field is only referenced as xsd:attribute, (possibly because it's a part of a repeating table) which won't accept the rich text complex type i copied from a test file.
            <xsd:complexType mixed="true">
                  <xsd:sequence>
                        <xsd:any minOccurs="0" maxOccurs="unbounded" namespace="http://www.w3.org/1999/xhtml" processContents="lax"/>
                  </xsd:sequence>
            </xsd:complexType>

Any help would be appreciated. I really don't want to have to go back again and redo all the forms in that folder.

Thanks!

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<xsd:schema targetNamespace="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-10-27T17:45:48" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2008-10-27T17:45:48" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<xsd:attribute name="Number" type="xsd:string"/>
	<xsd:attribute name="Work" type="xsd:string"/>
	<xsd:element name="myFields">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element ref="my:StudentName" minOccurs="0"/>
				<xsd:element ref="my:Date" minOccurs="0"/>
				<xsd:element ref="my:Program" minOccurs="0"/>
				<xsd:element ref="my:LessonNumber" minOccurs="0"/>
				<xsd:element ref="my:Exercise" minOccurs="0" maxOccurs="unbounded"/>
			</xsd:sequence>
			<xsd:anyAttribute processContents="lax" namespace="http://www.w3.org/XML/1998/namespace"/>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="StudentName" type="my:requiredString"/>
	<xsd:element name="Date" type="xsd:date"/>
	<xsd:element name="Program" type="xsd:string"/>
	<xsd:element name="LessonNumber" type="xsd:string"/>
	<xsd:element name="Exercise">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element ref="my:Part" minOccurs="0"/>
				<xsd:element ref="my:Item" minOccurs="0" maxOccurs="unbounded"/>
				<xsd:element ref="my:Checkboxes" minOccurs="0"/>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="Part" type="xsd:string"/>
	<xsd:element name="Item">
		<xsd:complexType>
			<xsd:sequence/>
			<xsd:attribute ref="my:Number"/>
			<xsd:attribute ref="my:Work"/>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="Checkboxes">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element ref="my:Checkbox1" minOccurs="0"/>
				<xsd:element ref="my:Checkbox2" minOccurs="0"/>
				<xsd:element ref="my:Checkbox3" minOccurs="0"/>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	<xsd:element name="Checkbox1" nillable="true" type="xsd:boolean"/>
	<xsd:element name="Checkbox2" nillable="true" type="xsd:boolean"/>
	<xsd:element name="Checkbox3" nillable="true" type="xsd:boolean"/>
	<xsd:simpleType name="requiredString">
		<xsd:restriction base="xsd:string">
			<xsd:minLength value="1"/>
		</xsd:restriction>
	</xsd:simpleType>
	<xsd:simpleType name="requiredAnyURI">
		<xsd:restriction base="xsd:anyURI">
			<xsd:minLength value="1"/>
		</xsd:restriction>
	</xsd:simpleType>
</xsd:schema>

Select allOpen in new window