Hi,
It happen because type("thisform.text1.value")='C' but your amount field is numeric format. Set thisform.text1.value = 0 in design mode

Denis


>I have a Textbox which I have set the format to R and the inputmask to 99.99. When a figure is inserted and a button pressed the value is inserted into a table called winnings. Therefore the on click event on the button is:
>
>

>IF thisform.Optiongroup1.value = 1
>	USE winnings
>	INSERT INTO 'winnings' (amount) ;
>  	 VALUES  (thisform.text1.value)	
>ENDIF
>

>
>On the amount field in the winnings table I have set this to numeric but I am recieving a data type mismatch error. Can anybody help me please?