Hi John! Two points of concern here.
First, try to do an format conversion, using Val( string_expr ) to convert whatever the user puts in to a numeric value. Mind you, the user might key in characters in which case the function may return zero. So I would check for that in some way. Secondly, you write that the input is to be multiplied by an integer value. But the result will probably not be an integer, so it must be written to a float or decimal column. But I guess you have thought of that. HTH and Best regards Mats.E ________________________ FB Engineering AB S�dra F�rstadsgatan 26 211 43 Malm� Tel: 040-665 64 80 Mobil: 0705-27 60 27 Fax: 040-665 69 90 e-post: [EMAIL PROTECTED] http://www.fbe.se [EMAIL PROTECTED] 2004-05-05 17:39 Till [EMAIL PROTECTED] Kopia �rende MI-L Using edittext control I am trying to use the EditText control to enter in values to use later in the program to update a column. Each value will be a decimal value somewhere between .000 and 1.000. Each value will be multiplied by an Integer column in an existing table. When I try to update the column, it tells me that I need numeric values. I'm not sure if this is related to the table or the text boxes. Any help is appreciated. John Crouse Integras Consulting Decision Support Analyst --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11646 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11647
