Format / Validation / Input Mask

[shearness]

I am trying to create a text box that stores a negative dollar amount
without having to manually key the minus sign.



I have tried input masks, formats, and validations, but cannot get the
value to store as negative, without manually entering it as such.



I am using Access 2000 for my front end and SQL Server 2000 as the
backend. The datatype is smallmoney.



Any help is appreciated.

 

[Al Camp]

Shearness,
Use the AfterUpdate event of your money field (ex. name = [Discount]),
and use this code...
[Discount] = Abs([Discount]) * -1
Using the Abs function will cause a Positive OR Negative user entry to
always result in a Negative number.

 

[shearness]

Al:



Thank you. That did the trick. I appreciate the help.



Eric