Changing Field Type - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Changing Field Type

Last post 05-12-2006 08:01 PM by taenkarth. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 05-09-2006 01:09 PM

    Changing Field Type

    Me again. ;-)

    I have a status report form in which I created text fields in a repeating table. After using for some time, I now realize RTF fields would be better so users can insert hyperlinks to deliverables, and add other attributes. Is there any way to change that field type without losing the existing data in the forms?

    Thanks.
  • 05-09-2006 06:41 PM In reply to

    If I understand the question correctly you probably would have go into the manifest and manually modify.
    Jason
    http://www.k2distillery.com/
  • 05-09-2006 07:58 PM In reply to

    This is an interesting question, and I'm curious to know exactly how this would be done, too. I'll ask some of our Microsoft MVPs if they know of the perfect solution.
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 05-09-2006 08:06 PM In reply to

    • jimbob
    • Top 500 Contributor
    • Joined on 11-26-2004
    • USA
    • Posts 32
    I believe it should just accept the old text data. If you have a richtext field with no formatting, you should notice it looks like standard text. But going from richtext to text would be a totally different issue.
    Jim Cantwell
    InfoPathDev - Redmond
  • 05-09-2006 08:36 PM In reply to

    I would have to agree with jimcan. Should work fine going from text to rtf. Might have to set your form options to automatically update existing forms under Form Options -> Advanced. Also you might have to change the datatype of the XML datafield...Let me check.

    Ok I just did this...
    1. Created new form and added repeating table with three text fields
    2. I saved the template, ran it, and typed data into a text field and saved as xml file.
    3. I then reopened my template in design view and deleted my textbox
    4. I then went to the data field it was bound to and reconfigured its data type to RichText and applied.
    5. Then in my data sources view i just clicked the filed dropdown and chose RichTextBox and added it to my form.
    6. i made sure my form was set to Automatically upgrade existing forms and I saved my template again.
    7. I ran my xml file I saved from before and it worked fine.

    Hope that answers your questions. let me know if you run into problems.
  • 05-12-2006 11:14 AM In reply to

    Thanks for the reply, taenkarth.

    How do you accomplish step 4? When I right-click on the data in the Data from the task pane I don't see where I can change the field type to Rich Text. Is it expression box?
  • 05-12-2006 11:25 AM In reply to

    Never mind. I got it working. Perfect! Thank you!
  • 05-12-2006 08:01 PM In reply to

    Sorry I did not get to you sooner.

    Glad to see ya got it working though!
Page 1 of 1 (8 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.