scale of linked tables in access

[Neil]

I have a field in SQL that has a precision of 11 and a scale of 4 (9
decimals to the right and 4 to the left of the decimal places). When viewed
as a liked table in Access this is rounded to 2 decimal places. When a user
enters a number with 4 decimals in the table it appears to them as only 2
but is correct if I query the SQL server directly.

Is there some setting in access that will allow me to see all 4 decimals on
linked table?

 

[Allen Browne]

9 + 4 = 11 ???


On a different note, Decimal fields don't work correctly in Access anyway:
http://members.iinet.net.au/~allenbrowne/bug-08.html

 

[M.L. Sco Scofield]

It sounds like you may be using the Currency format and have the Decimal
Places property set to Auto. Auto only gives you two decimal places for
display purposes regardless of what your scale is set to. As the format is
for display purposes only, doing arithmetic on the field will see all of the
positions.

Try changing the Decimal Places proper from Auto to 4.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Neil]

9 + 4 = 11 ???

YOW! bad math! yes I meant 7 and 4. sorry and thanks for the help

 

[Allen Browne]

So that wasn't the issue?

If you are still stuck, you could create a form (use datasheet view if you
want it to look like a table), and set the properties of the text box to:
Format Fixed
DecimalPlaces 4