R rciolkosz Jan 7, 2010 #1 Any help on how to make the form input to always show negative with brackets around it.
T Tom Wickerath Jan 13, 2010 #2 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/ __________________________________________
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/ __________________________________________
T Tom Wickerath Jan 13, 2010 #3 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/ __________________________________________
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/ __________________________________________
