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.
--
Rick B
"schasteen"
wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10174-convert-s-to-negative.html
news:E28CB6BB-0591-43B1-8B78-F416E68DBF58@microsoft.com...
> 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
>> far
>> I haven't been able to think of a way to do this. My hunch is that its
>> easier
>> 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
>> be
>> greatly appreciated. I'm a novice in VBA.
>> Adam