Make Number Negative Automatically

[tsgtnissen]

My Skill Level: SUPER BASIC, but doing my best to learn.

Question Setup:I have attached a picture of an order form I am working on.



Problem:In the "debit" field I would like to take any number that is input and have access convert it to a negative number.

My Research:I have looked all over the net and this is what I have found.
Potential Solution: -1*.'I don't know where to insert this. I have tried over in the properties tab with no luck.


Potential Solution:-1 * abs(mynumber) 'I don't know where to insert this. I have tried over in the properties tab with no luck.
Potential Solution:

public function neg(x as number) number
neg=-1 * abs(x) 
end function

I dont know where to put this. Should I put in the afterupdate or beforeupdate?

My crappy fix ATM:




Thank you all for your time. I have tried to lay this question out as clear as I can. Please let me know if you need any more information.

V/R
TSgtNissen

[NTC]

in the AfterUpdate event of the debit field put:

me.Debit = 0-me.Debit

that is all you need. You can remove the table field validation rule.

[tsgtnissen]

I get this error when I do that.

This form is looking is used to add orders to a table "GPC"
The forms record source is: GPC

[ssanfu]

I tested this and it worked. If your control name is not "debit", change "debit" to your control name.

Private Sub debit_AfterUpdate()
    Me.debit = -1 * (Abs(Me.debit))
End Sub

As NTC stated, you can remove any table or control level validation rule.

[tsgtnissen]

Thank you so much! That works!

[ssanfu]

You're welcome.....

[IslandHydro]

in the AfterUpdate event of the debit field put:

me.Debit = 0-me.Debit

that is all you need. You can remove the table field validation rule.

The OP asked to have the number end up negative regardless of what is input (+ or -) Simply using =0-me.Debit will result in a positive number if the user enters a negative number. =0-Abs(me.Debit) will always return a negative.