Restrict values to negative numbers

[jbrash]

I have a form that has a combo box where if i have a certain value I want to restrict the data to negative only values. My best solution was an IIf statement that multiplied the value by -1. I had problems if the user entered a negative symbol, the value would become positive. Any ideas will be much appreciated.

 

[joeyreyma]

set the combo box' VALIDATION RULE property to <0. this will force users to enter only negative values.

 

[jbrash]

Thank you for your quick response. The validation occurs in a separate field. I have two values that should format as <0 and two values that should format as >0 (Example: Choosing "Payout" from the "Transaction" field will restrict the "Contribution" field to <0, while choosing "Company Contribution" will restrict the value to >0.

[This message has been edited by jbrash (edited 07-23-2001).]

 

[ElsVanMiert]

I would use the BeforeUpdate-event of the appropriate fields. Then you can change the legal values according to your conditions easily.