asked on Format Currency $#,##0.00_);[Red]($#,##0.00)
Experts: how can I format the below as red. The Outgoing Amt is always negative and the data displaying is in data format and I do not want it in a form. I need to apply the formatting as found in Excel: $#,##0.00_);[Red]($#,##0.0
OutgoingAmt: Format(IIf([Debit / Credit Indicator]="D",[Amount]*-1
OutgoingAmt: Format(IIf([Debit / Credit Indicator]="D",[Amount]*-1
Microsoft Access
Last Comment
pdvsa
ASKER
Yes and with the parenth. Its in data sheet (query design window). I dont see the conditional formatting functionality in data sheet. I think I would need to apply the format either in the formula itself (replacing "Currency" with that $#,##0.00_);[Red]($#,##0.00) or in the properties sheet but the $#,##0.00_);[Red]($#,##0.00) doesnt format as such in the properties sheet.
I did checked on Excel...is something that i have never used before...but my original suggestion is probably what you need.
Just format the value as Currency and use Conditional formatting to turn Fore Color to red if Value <0
Just format the value as Currency and use Conditional formatting to turn Fore Color to red if Value <0
Datasheet....hmm... never use them...too restricted...i always go with Continuous forms...let me check
CF works fine on datasheet
Well just switch your form to Design View.. go to Format Tab..select the field in question and Create new Rule in Conditional Formatting.
ASKER
John, sorry but its not a form though. I am in an append query. I dont think there is formatting like that in an append. If so let me know.
The datasheet you mentioned is not a form?
if it's plain query I think you cannot apply color formatting...
if it's plain query I think you cannot apply color formatting...
ASKER
no its not in a form. It is an append. Plain query. I thought maybe there was some way to apply the shading like you can apply the currency format but seems like only currency can be applied and nothing on top of that (ie red)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Nice. It works. Thank you very much!
I did modify:
[Black]0.00;[Red]\-0.00;[Blue]0.00
to:
[Black]0.00;[Red]($#,##0.00);[Blue]0.00
I did modify:
[Black]0.00;[Red]\-0.00;[Blue]0.00
to:
[Black]0.00;[Red]($#,##0.00);[Blue]0.00
If this is the case then you need Conditional Formatting...