Preventing a Negative Operator at the end of a Field

[JennJenn]

I am trying to prevent a user from entering a negative operator at the end of a field ina form. For example, if the user puts .2548- or 3.21- instead of -.2548 or -3.21. I am limited in what I can do with this because my tables must be set up as text fields. Also, this field is not a currency field, so I can't format my text box as currency either. Can anyone give me suggestions on how to do this?

Thanks
Thanks llkhoutx!
[This message has been edited by JennJenn (edited 05-30-2002).]

[This message has been edited by JennJenn (edited 05-30-2002).]

 

[llkhoutx]

Use the Len and Mid functions to test the last character of a textbox on event BeforeUpdate for the textbox. You can then correct it, or merely strip it off.

 

[JennJenn]

This application interfaces with another one and in order for the data in both systems to sync properly, this is the way it had to be set up. I really wish that I could change it but I have to work around this.