If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Currency Format not working
Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form].
[txtAcctTotal],"Currency") Format: $#,##0.00;($#,##0.00)[Red] I have also tried the following Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form]. [txtAcctTotal],"$#,##0.00;($#,##0.00)[Red]") In both cases, the Color is NOT Red when the value is negative. Can someone explain why? |
#2
|
|||
|
|||
Currency Format not working
On Wed, 27 Jan 2010 14:50:05 -0800 (PST), iamnu wrote:
Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form]. [txtAcctTotal],"Currency") Format: $#,##0.00;($#,##0.00)[Red] I have also tried the following Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form]. [txtAcctTotal],"$#,##0.00;($#,##0.00)[Red]") In both cases, the Color is NOT Red when the value is negative. Can someone explain why? Because you're tripping over your own feet. The Format() *FUNCTION* returns a text string; applying the textbox's Format property on top of that is messing you up (since the textbox's format property expects a numeric Currency value, not a text string). Try setting the control source to just txtAcctTotal itself, and use the format property as in your first example. You may need all four format options (positive, negative, zero and Null): $#,##0.00;($#,##0.00)[Red];"$0.00";"Unknown" -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Currency Format not working
On Jan 27, 6:44*pm, John W. Vinson
wrote: On Wed, 27 Jan 2010 14:50:05 -0800 (PST), iamnu wrote: Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form]. [txtAcctTotal],"Currency") Format: $#,##0.00;($#,##0.00)[Red] I have also tried the following Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form]. [txtAcctTotal],"$#,##0.00;($#,##0.00)[Red]") In both cases, the Color is NOT Red when the value is negative. Can someone explain why? Because you're tripping over your own feet. The Format() *FUNCTION* returns a text string; applying the textbox's Format property on top of that is messing you up (since the textbox's format property expects a numeric Currency value, not a text string). Try setting the control source to just txtAcctTotal itself, and use the format property as in your first example. You may need all four format options (positive, negative, zero and Null): $#,##0.00;($#,##0.00)[Red];"$0.00";"Unknown" -- * * * * * * *John W. Vinson [MVP] Okay, thank you, sir! |
Thread Tools | |
Display Modes | |
|
|