In my [CONTACTS] file I have a portal from the [sALES DEATIL] file with the field InvoiceDate. This allows us to see the activity of each of our customers prior to making sales calls and gives us an idea of what kind of business we do with them. This is also a good time to see what the customer payment status. We don

quote:

---

Originally posted by foodsman:

In my [CONTACTS] file I have a portal from the [sALES DEATIL] file with the field InvoiceDate. This allows us to see the activity of each of our customers prior to making sales calls and gives us an idea of what kind of business we do with them. This is also a good time to see what the customer payment status. We don

If you want to have the actual text display in different colours instead of a background...

define 2 new calculation date fields... DateBlack and DateGreen.

code:

---

DateBlack = if(InvStatus="I",InvoiceDate,Date("","",""))

DateGreen = if(InvStatus="P",InvoiceDate,Date("","",""))

Now, in layout mode, format DateGreen as green text and format DateBlack as black text. Make both fields transparent and lay one over the other. The date calc is needed to avoid a ? appearing in an empty date field.

No real limt to this. I have used it in the past to make overdue items Red, due within 1 week Orange, within 1 month Green and more than 1 month Blue - got a bit tough on the eyes 'though.

Russ

[ April 11, 2002, 04:09 AM: Message edited by: Russell Baker ]