commas in form fields

  • Thread starter Thread starter Leesa
  • Start date Start date
L

Leesa

Hi, I have two problems with form data.

I am using .asp pages and feeding form data to an
Access2000 database. One of my fields asks the user to
type in a dollar value. The comma in the text field
causes problems when the form is submitted to the
database. I think the comma breaks up the data and the
follwing info in inserted into the wrong database field.
Does it move it over one column? Work around? I have the
$ sign outside the text field so they would be entering
something like 12,234.43

The second problem. In a text field the user will use the
[enter] key. This causes one record to end and another to
start so we have two 1/2 records.

Thanks. Leesa
 
A quick just told me that I can enter 12,123.23 into text, curreny or number
datatypes, so I would suggest that the issue is not in Access, but in the
page. Unfortunately, I know nothign about ASP
 
Back
Top