If Value < or > Caption Equals Invoice or Credit Invoice

[burrina]

My issues is this; If my Invoice amount is greater than 0 then I want to set the label to Invoice, if not Credit Invoice



Problem is that if there is a negative amount, i.e. a Credit Invoice due, then code does not work, only shows Invoice.

Right now it shows Invoice and that;s it, even though one record is a Invoice and the next a Credit Invoice.

What am I doing wrong?

If Me.GrandTotal < 0 Then
Label1000.Caption = "Credit Invoice"
ElseIf Me.GrandTotal > 0 Then
Label1000.Caption = "Invoice"
End If

[pbaldy]

In a form, you'd need to have a textbox with this type of thing:

=IIf(GrandTotal < 0, "Credit Invoice", "Invoice")

Code like that could work on a report, but won't work on a continuous or datasheet form. It could work in a single view form, with the code in the current event.

[burrina]

Cool, that worked. Man, I wish had learned this when I was young and mt brain actually worked.

"Sometimes the solution is not to fix the problem, but instead use a different approach"

Thanks,

[pbaldy]

Happy to help.