Negatives in Parenthesis

D

Dwight

Registered User.

Local time

Today, 12:59

Joined

Mar 17, 2003

Messages

168

• Jul 11, 2005

• #1

I want negative numbers on my report to be in parenthesis rather then have a preceding negative sign i.e. I want (10) for -1 but I don't want them converted to string values. Is this possible?

I worked with the FormatNumber function but I only succeded in generating errors.

As always,

I appreciate the help.

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 12:59

Joined

Jul 9, 2003

Messages

17,652

• Jul 11, 2005

• #2

Would it be possible to Base your report on a query?

You could then convert the negative values to the format you require with a simple if statement in the query. This would in no way affect your existing data, and you should get the report format you wanted.

Off the top of my head, the if statement would be something like this:

IIf (yourVal < 0, "(" & yourVal & ")", yourVal)

 

O

oldaf294

Registered User.

Local time

Today, 12:59

Joined

Mar 29, 2002

Messages

91

• Jul 11, 2005

• #3

select in the "format" section of "Design View" enter
$#.00;($#.00 [Red])
that will make Positive numbers black and negative values red with () around the number. If you don't want red, remove the [Red] from above

 

D

Dwight

Registered User.

Local time

Today, 12:59

Joined

Mar 17, 2003

Messages

168

• Jul 12, 2005

• #4

Perfect Oldaf294!

I've adapted your method to my needs and it works great.