Scientific Notation Not working

[schenel]

I have several textboxes that hold very small values like for instance 2.2 X 10-8 (2.2e-8). However, just selecting Scientific for the format property doesn't seem to be working correctly. If I type in 2.2e+8 then the display is the same. But, if I enter 2.2e-8 the display changes to 00.e00.

How can I get Access to keep what I typed. I've played with the decimal property, the width of the textbox and other properties to no avail.

Any help is greatly appreciated.

Ernie

 

[indesisiv]

Strange

I have just tried it ....

Just created a text box and set the format to scientific
also set the decimal places to auto.

Seems to work fine

May be that if they are bound to a field in a table you have not set that correctly....

If they are unbound i am not sure.

 

[schenel]

I found the answer:

I quickly created a test form and put an unbound textbox on the form and set the format property to scientific.

Just like you said, it worked. So, that did lead me to believe the problem was with the table to which my original textbox is bound.

The table field size property was set to long integer instead of single or double. Once I fixed this, the data entered correctly in the textbox.

Thanks for your help.

 

[KeithG]

In the table design you can change the format of a field to scientific to get you data into scietific notation. You can use the len funtion to retrieve the number of digits in a string/number