Change field in table then update in form without deleting/readding

[HackerMan]

is there any way that if you change the data type in a table, that you can update the existing field in a form to match without having to delete and re-add in the new format?

[Minty]

What's the Control type? If it's a textbox, not much would change, what is the data type being changed from / to ?

[HackerMan]

being changed from yes/no to a short text combo box of "Yes";"No"

[Minty]

Oooh okay, If you want my personal advice I wouldn't do that.
What is driving you to make this change. You can easily make the combo display Yes or No, and still store the boolean datatype.

[Micron]

Actually, Allen Browne advocates the use of text boxes instead of yes/no fields, so why would you not do that? I'm assuming this

being changed from yes/no to a short text combo box of "Yes";"No"

means currently it's a check box. Yes/No isn't a control type - it's a data type. If your table field is Y/N you can format it to Yes No, True False if that helps. Regardless, a combo will display any of these with the added benefit of allowing you to store Null in the record.

[HackerMan]

I wanted to switch from a check to a drop down to keep the null value (in case someone entering data missed the question)