Set colors of positive and negative numbers

If your table contains two types of numbers (positive and negative) and you want to distinguish these two types by setting the different colors, follow the instructions:
- Open the table that contains the two types of numbers above in design view
- Click the field of positive number or negative number
- Type this code"$#,###.00[Blue];($#,###.00)[Red]"in the Format property

Posted by: Solin | post date: 11-27-2012 | Subject: MS Access




    This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
    C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.