MS Access data conversion - scale in linked access table

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

scale in linked access table

KARL

2005-04-06, 8:04 pm

Right click the display field and open properties.
Change decimal places to 4.
>-----Original Message-----
>
>
>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?
>
>--
> Neil MacMurchy
>.
>

Sponsored Links