Report formatting for negative values (2000(9.0.3821 SR-1))

Topic

New Reply

Is there a way of displaying negative values or summaries thereof in brackets (like in Excel) in Access reports?

Cheers,

Niven

Reply | Quote

Replies

You can set the Format property of the text box(es) to a custom format, for example

0;(0)

for whole numbers, or

0.00;(0.00)

for numbers with 2 decimal places, or

Reply | Quote

Yes of course, Amazing what you forget!

Cheers,

Niven

Reply | Quote

I always have trouble remembering what I have forgotten

Reply | Quote