Formatting text boxes that display values

[GOVMATE]

I'm not sure how get negative numbers to appear in parenthesis. I used the Format function inconjunction with the Sum function to aggregate a field called "Net Difference No of Claimants" that exists in a table.

I've tried variations of the following function;

=Sum(FormatNumber([Net Difference No of Claimants,UseParensForNegativeNumbers])).

I'm using Access 2003 and when I attempt to view the print version to see if the function is working properly I'm asked to enter a parameter value for "Net Difference No of Claimants,UseParensForNegativeNumbers"

 

[rainman89]

is "Net Difference No of Claimants" stored as a # in your table?

 

[pbaldy]

Look at help on the format property of the textbox, specifically custom number formats.

 

[GOVMATE]

is "Net Difference No of Claimants" stored as a # in your table?

Yes Net Difference No of Claimants is stored as a #. Each time I attempt to use what is suggested for the Format function in the help menu and then attempt to view the form in print view, access treats the function as a parameter function.

 

[pbaldy]

Did you look at the Format property of the textbox? That's what I would use. Your syntax in the function is incorrect, as you've bracketed the whole thing, make it look like one big field name.

 

[GOVMATE]

Did you look at the Format property of the textbox? That's what I would use. Your syntax in the function is incorrect, as you've bracketed the whole thing, make it look like one big field name.

The format property is set to general number. I used the following syntax =Sum(FormatNumber([Net Difference No of Claimants,UseParensForNegativeNumbers])) and it still doesn't work. Does anyone have suggestions?

Thanks!

 

[pbaldy]

Like I said, a custom format such as:

#,###.00;(#,###.00)

instead of General Number.

 

[GOVMATE]

Thanks pbaldy!

I figured it out!