>Hi All:
>
>I have a drop down combobox which is populated by a SELECT statement. This is a Numeric field in the original table. I also have a textbox that displays thechoice made from teh combobox.
>
>In the InterActiveChange Event of the Combobox, I have the following code:
>
>
mSelectedNumber = this.value
>
>However, what is now stored in mSelectedNumber appears to be a character string. How do I convert the contents of variable mSelectedNumber to Numeric type?
>
>Thanks in advance.
Check out VAL() function
>
mSelectedNumber = val(this.value)