>Nadya,
>
>I don't understand what your goal is here. A Textbox can handle any data type at all. The data type is determined by the controlsource or the value initially assigned to the textbox.
Hi Jim,
Yes, I know, that initial value would determine the data type.
Let me explain the problem more precisily: We have a form called "Global Editor". It has a combobox with fields, which could be replaced with some value, whcih a user can enter in a textbox. Now there is a problem: how can I figure out, what data type value is entered? I thought about doing this in opposite way: after user selects a field from combobox, check its type and either use appropriate InputMask or Format property or AddObject(correctFieldTypeTextBox) and Remove the previous textbox. It would be a little hassle.
So, what do you think? Which idea is better?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog