Negative Currency

Greetings all,

I need to be able to make a series of labels in a user form to display a -ve
currency value in Red

For non -ve value I have no problem
Results.Controls("AProfit" & i) = Format(a - c, "$#,##0")

but I can't make it It trurn red with a -ve value

Results.Controls("AProfit" & i) = Format(a - c, "$#,##0;-[Red]$#,##0")

Any suggestions would be appreciated

Use the forecolor property of the label.

--
Regards,
Tom Ogilvy

"David Adamson" <d.adamson1@uq1.edu.au> wrote in message
news:dd69l5$2bh1$1@bunyip2.cc.uq.edu.au...
> Greetings all,
>
> I need to be able to make a series of labels in a user form to display
a -ve
> currency value in Red
>
> For non -ve value I have no problem
> Results.Controls("AProfit" & i) = Format(a - c, "$#,##0")
>
> but I can't make it It trurn red with a -ve value
>
> Results.Controls("AProfit" & i) = Format(a - c, "$#,##0;-[Red]$#,##0")
>
> Any suggestions would be appreciated
>
>
>

Thanks for that.




"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:u4YbzS7mFHA.3608@TK2MSFTNGP15.phx.gbl...
> Use the forecolor property of the label.
>
> --
> Regards,
> Tom Ogilvy
>
> "David Adamson" <d.adamson1@uq1.edu.au> wrote in message
> news:dd69l5$2bh1$1@bunyip2.cc.uq.edu.au...
>> Greetings all,
>>
>> I need to be able to make a series of labels in a user form to display
> a -ve
>> currency value in Red
>>
>> For non -ve value I have no problem
>> Results.Controls("AProfit" & i) = Format(a - c, "$#,##0")
>>
>> but I can't make it It trurn red with a -ve value
>>
>> Results.Controls("AProfit" & i) = Format(a - c, "$#,##0;-[Red]$#,##0")
>>
>> Any suggestions would be appreciated
>>
>>
>>
>
>