Decimal Places is a display formatting. It doesn't affect the actual stored value. Clicking into the box will reveal the actual value. That's the way it is!
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you my friend
Is it possible that Mark field does not show decimal places but show the value of the dollar?
Don't understand. Mark is the name of your field? The image shows a field with dollar value.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I mean the number remains in but at the same time remaining sign $
Still confused. The image shows value with $ sign.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.