TextColor with Number field

November 10, 200520 yr

Hi all,

So, here's the story...

The users want to be able to have a new line item on a purchase order pull in the last price at which they bought that item. And, they want the "read in" price to be in black on the layout. If, on this occasion, we are purchasing the item for a different price, the user needs to be able to overwrite the price that was provided from the last record; when this happens, the price should change to grey on the layout. Also, if we have never purchased this item before, the unit price field should be blank and the user can enter the price.

So, what I've tried to set up is an auto-enter calc which works beautifully AS LONG AS the field in question (Unit Price) is defined as a text field. But this won't do, since the field must display on the layout with a $ sign, etc. The calc I am currently using is:

Case(IsEmpty(UnitPrice);TextColor(Last ( poli_POLI~goodID::UnitPrice );RGB (0;0;0));

TextColor ( UnitPrice ; RGB ( 138 ; 146 ; 149 ) ))

I have fooled around with the GetAsText function and still no luck. Wondering if I need to adjust the calc to include the dollar sign and decimal points, etc. or if there's an easier way and I'm missing something.

Thanks for any input!

Kate