Left align currency symbol plus negative numbers in red

E

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top