Well, i don't where is the rest of the code, I just answered the problem "The value """" cannot be converted to a number."
Adding "0" at the begining of the string will assure that the string is always transformable to a number through the val() function.
Then if you are in a query,
UPDATE myTable
SET whatever = #val ("0" & form.var1)#
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

