Hi Neil,
try

INSERT INTO winnings (amount) ;
 VALUES  (val(thisform.text1.value))

>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?