commas in form fields

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
 
K

Kevin3NF

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Advice for field structure or query structure - not getting theresults I thought I should 2
Write Conflict 3
Access How to record date/time when specific field is modified in Access 2007 0
Excel VBA - Force 4 commas into a text field on userform 7
Access Automatically Send a notification email once a record is added 0
Reading Text Files w/commas in the data 5

Top