Convert #s To Negative

#1 (**permalink**) 28-Jul-2006, 08:10 AM

Hello All,
I am trying to set a control on a form to convert numbers typed into the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10174-convert-s-to-negative.html
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
Adam

*

#2 (**permalink**) 28-Jul-2006, 08:10 AM

Have you tried in the before update event of your text box
Me![TextboxName] = Me![TextboxName] * -1

"F1stman" wrote:

> Hello All,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
> 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

#3 (**permalink**) 28-Jul-2006, 08:10 AM

I would find the absolute value, then multiply it by -1

I would put this in the before update event. Something like..

fieldname = Abs([fieldname])*-1

--
Rick B

"F1stman" wrote in message
news:AA321CA5-A42D-4838-B763-34E2BE2EFDDA@microsoft.com...
> Hello All,
> I am trying to set a control on a form to convert numbers typed into the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174
> 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

#4 (**permalink**) 28-Jul-2006, 08:10 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10174

--
Rick B

"schasteen" wrote in message
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