Displaying Credit amounts as red

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Have a look at conditional formatting on the format menu.

HTH
Sam
anandgb said:
I have a Customer Inquiry Form that displays Custiomer Information and a
Click to expand...
linked subform that displays the transactions.
I would like to display the payments in red so that the person viewing the
Click to expand...
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.
 
Sam,
Thanks very much. That worked. Do you know how I could change the color of the whole line?
 
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
anandgb said:
Sam,
Thanks very much. That worked. Do you know how I could change the color of
Click to expand...
the whole line?
 
anandgb said:
Do you know how I could change the color of the whole line?
Click to expand...


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.
 
Back
Top