Format question

J

Jack

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.
 
F

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.
Click to expand...

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.
 
J

Jack

Thanks for your kind help.

fredg said:
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.
Click to expand...

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.
Click to expand...
 
Top