MS Access linking to MS SQL tables

[OdeonKreel]

Got a small problem. I have linked MS Access to a bunch of MS SQL tables. But MS Access tries to be more intelligent and starts reformatting the data for me. Bad.

In SQL I have a few fields that are numeric,10,4. 4 decimal places.
But when I link to the table from Access, Access then decides to call the number a currency value, and will only display 2 decimal places. How do I force Access to display 4 decimal places, instead of it reformatting to what it thinks is best?



MS Access 2007
MS SQL Server 2008

[RuralGuy]

There is a Format property for fields in tables as well as in controls on forms. Where are you seeing the 2 decimal place format?

[OdeonKreel]

Thanks. I can't believe I missed that. Fixes the problem.

[RuralGuy]

Great! Are you ready to go ahead and use the Thread Tools and mark this thread as Solved?