alter a controls data type

[Richey]

I have a text box control on a form, with a control source bound to a text field in a table.
I'd like on the click of a button to, for example, change the data type to numeric or percent or a date.
Is this possible?

regards

 

[MSMINNICH]

How about if you unbind the control and then plug in your value when you click on the button? You could use the Format function to reformat the field. I guess what I'm wondering is how you'll use the result. Do you need to change the datatype or just change the way the data looks?
Scott