Solved

Changing colors of the field based on the input

Posted on 2014-12-10
3
89 Views
Last Modified: 2014-12-10
How do you make a field red if the field is a number and the number is negative?
0
Comment
Question by:Jass Saini
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 40492341
you can use conditional formatting

select the control and click Conditional formatting

Field Value is    less than        0

select the red for background
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40492504
Conditional formatting is too slow for this if the field is numeric.

Set the Format property of the field to:

   0.00,\-0.00[Red]

/gustav
0
 

Author Closing Comment

by:Jass Saini
ID: 40492783
thanks
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now