Have you tried in the before update event of your text box
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10174-convert-s-to-negative.html
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
> 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