if statement problem

[Mac rod]

hi,

i want a text box to show "change" if the value of total is less than zero and "balance" if the value is greater than zero. i tried this code on the afterupdate event but it won't work. please help...

If Me.txttotal < 0 Then
Me.txtchange = "change"
ElseIf Me.txttotal > 0 Then
Me.txtchange = "balance"
Else
    ' do nothing
 
End If

[beacon]

Hi Mac,

I would use the BeforeUpdate event, not the AfterUpdate event. You're essentially validating the data in txtTotal, then updating the value in txtChange. Typically, all data validations are done using the BeforeUpdate event.

Of course, this assumes that the format for your txtTotal textbox is setup to allow for negative values.

Also, in case you want to reduce the number of lines of code, you really don't need the 'Else' part of your 'If' statement if you aren't going to test a condition.

[NeoPa]

Mac Rod:
but it won't work.

We'd have to know what you mean by not working Mac. You may have any weird expectation of this, but without saying what that is it's hard to comment.

Also, to check your code properly (an initial check confirms it's not tidy but it should nevertheless produce sensible results assuming all else matches - like object names etc), we'd need to see it in the context of its procedure at least.