String in database

[tiger99]

Hi I need to insert some number into MS Access 2003 database as text.
My problem is when I insert "3.8-4.0" it shows value "-0.2" and when I enter "1.0" it shows "1" in the database

I am using ASP but I have tried many ways to convert the number to string etc... and non of them work.

Is there some configuration in MS Access that I can set to resolve this problem?

Note: when I output the value of the variable on the ASP page, it shows the correct value

Appreciated your help

 

[KenHigg]

...And you have the fld set as a text fld?

???
kh

 

[tiger99]

Yes..it's a text field

 

[KenHigg]

Can you chop out a small enough pc of the effending db to post up a sample?

kh

 

[WayneRyan]

tiger,

"3.8-4.0" shows value "-0.2"
"1.0" it shows "1"

It's not taking your entry as a string, it's evaluating them as a formula
for some reason. At least its results are correct.

What's the Format for the Control?

Wayne

 

[tiger99]

Are you talking about the Format for the MS Access text field?
Currently, it's empty.
How could I set it to display only string?

Thanks