TextColor with Number field

[KateJ]

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

[mr_vodka]

Kate there was a post regarding almost your same issue yesterday. Please check out this thread.

Thread

[KateJ]

So sorry... I promise I did surf and try to find a post...but obviously not thoroughly enough!

And yes, this works and it's beautiful. Many, many thanks.

Kate