Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Void scientific number when link to SQL server

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2007-03-06 : 10:01:31
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).
How to void it and always display standard number?

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2007-03-08 : 09:33:30
I got it!
In the table design mode, refer to the format section for the field. Set it to "fixed Number"
Go to Top of Page
   

- Advertisement -