[AccessD] How to display positive or negative number in report

[Gustav Brock]

Hi Kostas

Oh, that's right - the original purpose of the functions was just to indicate positive/negative.

Use Abs to correct:

    ="some text <b>" & SgnStr([score]) & CStr(Abs([score])) & "</b> some other text"

/gustav


________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Kostas Konstantinidis <kost36 at otenet.gr>
Sendt: 6. juni 2015 13:41
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] How to display positive or negative number in report

Gustav,
just noticed that if the number is negative e.g. -2 it returns double minor

some text --2 some text

thank's
/kostas