How to put a negative sign on a number based on the selection of a drop-down list?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Amy Badgett
    New Member
    • Feb 2011
    • 39

    How to put a negative sign on a number based on the selection of a drop-down list?

    I would like to create a form that allows users to enter in changes in transactions of inventory.

    Is there any way the number entered into a control text box can automatically have a negative sign come before it? Or could I base the fact that there is a negative on the number on whether a drop-down box control has "inbound" or "outbound" selected?
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32661

    #2
    You could change the value after it's been entered. The AfterUpdate event procedure could put in whatever logic you're looking for (Not quite clear exactly what from your explanation, but I'm sure you understand it well enough to implement it yourself). Clearly, that code could determine the selection of the ComboBox and use that for the desired result.

    Comment

    Working...