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