Format / Validation / Input Mask

  • Thread starter Thread starter shearness
  • Start date Start date
S

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.
 
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.
 
Back
Top