Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    122

    Unanswered: Format / Validation / Input Mask

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    The only thing you could do is to make a checkbox/radiobutton that would do the math for you (i.e. if neg then mult by -1) ... Otherwise you have to put the minus sign to signal that it is a negative number. If your mask was "Currency" you could use the left and right parens "()" as they denote negatives in currency ...

  3. #3
    Join Date
    Sep 2003
    Posts
    122
    Even when I use the currency mask and have the parenthesis, the value stored is not negative. It is displayed as a negative with parenthesis while in the field, but as soon as you tab off, it defaults back to a positive currency value. Any ideas?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •