Avoid scientific notation in my number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks Andy.

Pat

Andy Hull said:
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
Click to expand...
 
Back
Top