Format question

[Guest]

Hi,
I have the following line of code :
Me.ContractedServBudget = IIf(IsNull(cboSelectSubGrant.Column(8)), 0,
Format([cboSelectSubGrant].Column(8), "$#,##0.00 ;($#,##0.00)"))
I am not very clear about the way the above have been formatted. I am
looking for any article/or reference with regard to the above formatting. Any
help is appreciated.

 

[fredg]

Hi,
I have the following line of code :
Me.ContractedServBudget = IIf(IsNull(cboSelectSubGrant.Column(8)), 0,
Format([cboSelectSubGrant].Column(8), "$#,##0.00 ;($#,##0.00)"))
I am not very clear about the way the above have been formatted. I am
looking for any article/or reference with regard to the above formatting. Any
help is appreciated.

If the value in combo column(8) is a positive value (let's say 12345.)
it will display the value as $12,345.00.
However, if the value is negative, it will display it within
parenthesis as ($12,345.00).
For more information see Access Help.
Format property + Number and currency datatype.

 

[Guest]

Thanks for your kind help.

Hi,
I have the following line of code :
Me.ContractedServBudget = IIf(IsNull(cboSelectSubGrant.Column(8)), 0,
Format([cboSelectSubGrant].Column(8), "$#,##0.00 ;($#,##0.00)"))
I am not very clear about the way the above have been formatted. I am
looking for any article/or reference with regard to the above formatting. Any
help is appreciated.

If the value in combo column(8) is a positive value (let's say 12345.)
it will display the value as $12,345.00.
However, if the value is negative, it will display it within
parenthesis as ($12,345.00).
For more information see Access Help.
Format property + Number and currency datatype.