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?