Displaying Credit amounts as red

[Guest]

I have a Customer Inquiry Form that displays Custiomer Information and a linked subform that displays the transactions.
I would like to display the payments in red so that the person viewing the form can know it is a credit at a glance. Unfortunately since the subform shows multiple lines I cannot seem to be able to pinpoint an event that will allow me to code the background or foreground color. I am desperate for some guidance.

Thanks very much for any help

 

[Sam]

Have a look at conditional formatting on the format menu.

HTH
Sam

I have a Customer Inquiry Form that displays Custiomer Information and a

linked subform that displays the transactions.

I would like to display the payments in red so that the person viewing the

form can know it is a credit at a glance. Unfortunately since the subform
shows multiple lines I cannot seem to be able to pinpoint an event that will
allow me to code the background or foreground color. I am desperate for some
guidance.

 

[Guest]

Sam,
Thanks very much. That worked. Do you know how I could change the color of the whole line?

 

[Sam]

Why not just create a conditional format for each control. You'll need to
use Expression Is and refer to the control that contains the credit data in
your expression e.g. CreditControlName<0

HTH
Sam

Sam,
Thanks very much. That worked. Do you know how I could change the color of

the whole line?

 

[Marshall Barton]

Do you know how I could change the color of the whole line?

You could do the background for the entire line by creating
a text box that is the same size as the entire detail
section. Set this text box to Disabled and Locked and use
Conditional Formatting on it. Use Format - Send To Back to
put it behind all the other controls and make sure all the
other controls have their BackStyle set to Transparent.

 

[Guest]

Sam,
Thanks very much. That worked

 

[Guest]

Sam And Marsh,
Thank you very much for your feedback. I really do appreciate.

Anand