Left align currency symbol plus negative numbers in red

[Evi]

In my Access report I want my currency symbols to be left aligned (just as
the currency button does in Excel).
Using
£* #,##0.00

in the Format Property box

works fine

I have one control which has be red if the number is negative.

Using

£#,##0.00[Black];- £#,##0.00[Red]

works fine for that.

But I want to combine the two formats so that my Red/Black control also has
a left aligned currency symbol.

If, however I try to put

£*#,##0.00[Black];- £*#,##0.00[Red]

into the format box it exchanges the * for a \ and creates nonsense.

Is there a way of doing what I want?

Thanks

 

[Evi]

In my Access report I want my currency symbols to be left aligned (just as
the currency button does in Excel).
Using
£* #,##0.00

If, however I try to put

£*#,##0.00[Black];- £*#,##0.00[Red]

into the format box it exchanges the * for a \ and creates nonsense.

Try:

£* #,##0.00[Black];- £* #,##0.00[Red]

I think the character after the * is the one used to pad the text,
therefore in you case a space needs to follow the *.

Jamie.


You are a total genius Jamie, you've solved it!
Evi