How do i reduce or limit the decimal places in the calculated field below as mentioned
Novice
Windows 10 
Access 2013 32bit
How do i reduce or limit the decimal places in the calculated field below as mentioned
VIP
Windows 10 Access 2010 32bit
How are you generating those calcs? In textbox? Set DecimalPlaces property. However, property setting does not change the value. Calculations with this result will still use the full 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.
VIP
Windows Vista Access 2010 32bit
In the text box property, set format to FIXED , and Decimals = 2.
Formatting for 3 decimal places
Changing decimal places
Posting Permissions
Reply With Quote