Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing a plus entry to a minus entry 1

Status
Not open for further replies.

cschnable

Programmer
May 24, 2001
36
US
I have a payment form in which one of the fields is [amount].

How can I enter a number without preceeding the number with a negative sign every time I record a payment.

I want the number to go into the table as a negative without pressing the negative button every time I make an entry.

Any help will be greatly appreciated.
 
On the AfterUpdate Event for the amount field insert the line:

If amount > 0 then amount = - amount

[bigcheeks]
 
Thank you very much - WORKED GREAT!

I had a major mind lock (grin)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top