 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
01-06-2008, 04:30 PM
|
|||
|
|||
|
Postive negitive numbers in conditional formatting of a report
I have a money field, I like money owed in red, zero blanace white and
credited amounts above bill in green. Seems no matter what I due it treats Pos & Neg numbers and positive numbers. using access 2000. -- Frank 
|
|
01-06-2008, 04:58 PM
|
|||
|
|||
|
Re: Postive negitive numbers in conditional formatting of a report
Frank wrote:
> I have a money field, I like money owed in red, zero blanace white and > credited amounts above bill in green. Seems no matter what I due it > treats Pos & Neg numbers and positive numbers. using access 2000. Check the help file for the format property for numbers. When used against numbers the format property has four sections separated by semi-colons. They set formatting for Positive, Negative, Zero, and Null. Color is one of the things that can be set in this manner. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
01-06-2008, 04:58 PM
|
|||
|
|||
|
Re: Postive negitive numbers in conditional formatting of a report
Frank wrote:
> I have a money field, I like money owed in red, zero blanace white and > credited amounts above bill in green. Seems no matter what I due it > treats Pos & Neg numbers and positive numbers. using access 2000. Check the help file for the format property for numbers. When used against numbers the format property has four sections separated by semi-colons. They set formatting for Positive, Negative, Zero, and Null. Color is one of the things that can be set in this manner. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
