I have the same problem Lyman does... I have a form that requests
data from the user but it enters the data  into the field  formatted
as text. Error checking (the little triangle  in the cell) tells me
that it's a "Number Formatted as Text". But running a VBA routine to
change the number format  does not clear the text  formatting.

I also tried to record a macro for the manual "Convert to Number"
process you just described so I could grab the VBA code but it does
not perform the function. It sets the format to number but the error
checking is still there telling me that it is "Number Formatted as
Text".

What is the VBA function or statement that will do the "Convert to
Number" process? I think that is probably Lyman's real question too.
I even tried to clear the cell formatting and reformat it as a
number and it didn't work.

If there is no way to clear that formatting how do I set a the Text
form field to be a number instead of text? I don't see a property
for format in the field properties.