I have an access database with a field I describe as a decimal. USing an ADO recordset I have a form where I ask the user to enter this field. I then take this field and use it to calculat another field which I also display. Here's the problem, when the percent is entered ex (fielda as.06), the textchanged event is triggered which is where I want to do my calculation. Fieldc = fielda * fieldb. As soon as I enter the decimal point into the fielda on the entry screen, the event is triggered for the calculation but I get a type mismatch trying to do the calculation because of the decimal point. I know why it is happening but I don't know how to get around it. Any suggestions?
Thanks

cruella69