Negative numbers appear positive in a datasheet

[lana]

Hi there,
Is there a way with conditional formatting to change negative numbers to appear positive in a datasheet?
Thanks a lot

 

[arnelgp]

create a Query and add Expression that will turn negative to positive:

select *, Abs([numberField]) As Positive from your table.

use the Query as recordsource of your form.

 

[lana]

Thanks for the reply.
This changes the negative to positive. But I need the value to stay negative but only appears positive in the datasheet.
I have seen this in other programmes. When the number is selected it shows the negative value.
I think it's done with conditional formatting, but don't know how.

 

[lana]

I did it.
#,##0;[Red](#,##0) in filed format.
Thanks

 

[The_Doc_Man]

Congrats, lana, you found a perfectly good (and technically correct) solution. Even better, you shared it. Thanks for your contribution!