General discussion

Locked

Changing the forecolor in current field

By meares ·
I have a Access form that looks like a data sheet, and with row and columns. How do I change the one amount field if credit to have the forecolor of red with out changing the whole column of amounts to red?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Changing the forecolor in current field

by achp In reply to Changing the forecolor in ...

In constructor mode, select that field and use the "Format" property to specify the proper data format.

For numbers, data format consists of up to three parts separated by semicolons. The 1st part is used to format positive numbers, the 2nd is for negative numbers, the 3rd is for zero values. For example:
<pre>

#,##0.00;-#,##0.00[Red];""

</pre>
- means: use thousand separator, show two figures after the period; if the number is negative, show it in red; if the number is equal to zero, show nothing.

Collapse -

Changing the forecolor in current field

by meares In reply to Changing the forecolor in ...

Excellent it helped me a bunch!

Collapse -

Changing the forecolor in current field

by meares In reply to Changing the forecolor in ...

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums