Avoid scientific notation in my number field

[Guest]

I've imported a field as single format. Access displays it in scientific
notation but I don't want it to. How do I force it to display the full
number while maintaining the single format? Note that I need the field to be
in single format, not text format. I'm using Access 2003.

Thanks,
Pat

 

[Guest]

Hi Pat

Set the field's format to something like #,##0.00 (or whatever you want)

You can do this at the table level or on your forms.

By the way, Access 2004 also has a data type called Decimal which is exact
(unlike single) and allows you to specify how many digits it should hold and
how many decimal places - you may find this is a more appropriate data type
for this purpose.

hth

Andy Hull

 

[Guest]

Thanks Andy.

Pat

Hi Pat

Set the field's format to something like #,##0.00 (or whatever you want)

You can do this at the table level or on your forms.

By the way, Access 2004 also has a data type called Decimal which is exact
(unlike single) and allows you to specify how many digits it should hold and
how many decimal places - you may find this is a more appropriate data type
for this purpose.

hth

Andy Hull