Form input to be Negative

[rciolkosz]

Any help on how to make the form input to always show negative with brackets
around it.

 

[Tom Wickerath]

From Access 2003 Help (Press F1 with focus in the Format property, select
"Number and Currency Data Types", scroll to bottom of page):

Setting
0;(0);;"Null"

Description
Display positive values normally; display negative values in parentheses;
display the word "Null" if the value is Null.

If you do not want the word "Null" displayed, then use this format: 0;(0)


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Tom Wickerath]

PS. If you want square brackets around negative numbers, instead of the
parentheses shown in the Help file, then use this format:

0;\[0\]


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________