Access Incorrectly displays number as decimal

[episudics]

I have linked to an odbc datasource which is a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and 21. When I view the table in access the numbers appear like this, 5.161210817784058105E+18. How can I get the number to display correctly as a whole number.

 

[NorthNone]

Have you tried making the field display wider to give it more space to display?

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[episudics]

Yes I have it makes no difference.

 

[PHV]

And what happen with a display format like ##################### ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886