Didn't get noticed from Feb 7th

[DaveB]

My original question starts at the >>

-----Original Message-----


Could you describe what steps you took to "add a negative number", and
the actual error message? prehapse with the Control Source or the code
which calculates the price?


.

Sure thing. I simply added a minus sign before the number.
I found out that I would have to change 2 fields. I took
the Form directly from the Northwind Sample data base,
it's the Orders Form. The error message really isn't an
error message, it's just a message that says, "You must
enter a positive number. When I click on help it says
<Table-level validation text> (Error 3316)
My text is in dollar amounts which I would prefer to keep
that way. I just wish that I could make it accept
negative numbers also.

 

[Cheryl Fischer]

Open the Order Details table in design view and click on the Unit Price
field. Notice that in the properties for that field there is a Validation
Rule requiring that the entry be greater than or equal to 0. Delete the
rule and the validation text and you should be able to enter a credit
amount.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX