How to display negative numbers in parentheses (positive normally) in Microsoft® Access
Follow the instructions to display negative numbers in parentheses (positive normally) in Access:
Open the desired database.
Click the ‘Table’ tab.
Select the desired table object.
Click in the field that contains the ‘Number’ data type.
Click in the ‘Format’ property in the ‘Field Properties’ section.
Type the following code: #,###;(#,###)
Select the ‘File’ menu and select ‘Close’.
Click ‘Yes’ to save changes.
If the locale selected in the ‘Regional Options’ section of Microsoft Windows is set to a non-English then it is possible that the number/currency format, where negative numbers are displayed in parentheses, may be unavailable.