Scientific number in Access

[aspfun]

I used Access to link to a table in SQL server.
A column in SQL is uniqueid but in Access became scientific number(if number is bigger, e.g. more than 11 digital numbers).
How to void it and always display standard number?

for example,

10001000084
4.81531400018E+11 //can void it???
10001800006

 

[mhartman]

In the table design mode, refer to the format section for the field. Set it to "General Number"

Regards

 

[aspfun]

Thank you, Dr. data, you gave me a point.
"General number" did not work but "fixed number" work.

 

[mhartman]

10-4 and good luck with this.