This will work, unless the number is already entered as a negative. In
other words, if one enters -10, this would turn it into 10.
"schasteen" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10174-convert-s-to-negative.html
> Have you tried in the before update event of your text box
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
> Me![TextboxName] = Me![TextboxName] * -1
> "F1stman" wrote:
>> Hello All,
>> I am trying to set a control on a form to convert numbers typed into the
>> text box to a negative number and then store that number to the table. So
>> I haven't been able to think of a way to do this. My hunch is that its
>> than I am making it. Thank you for any and all assistance. Oh, by the
>> way, if
>> you could explain how to use and where to put any code offered that would
>> greatly appreciated. I'm a novice in VBA.