validation rule not running right with larger decimals in play

[sheckay]

Further testing.


Expected Size Tolerance +/- lowest possibility outcome
.555 .01 .545 accepted
.555 .001 .554 accepted
.555 .0001 .5549 accepted
.555 .00001 .55499 accepted
.455 .0002 .5548 accepted
.655 .0002 .6548 accepted
.555 .003 .552 accepted
.555 .0003 .5547 accepted

[sheckay]

The spacing of my prior post was thrown off, I apologize

[Welshgasman]

This works for me. I entered all required values?
All fields are Single as advised by @Micron

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.ToleranceSize > Me.ActualSize Then
    If Round(Me.ActualSize + Me.TolerancePlus, 4) > Me.ToleranceSize Then
        MsgBox "Out of tolerance"
    End If
Else
    If Round(Me.ActualSize - Me.ToleranceMinus, 4) < Me.ToleranceSize Then
        Cancel = True
    End If
End If
    
End Sub

[sheckay]

When I ran the tests above, I also tested going lower than the least possible value in the range, to make sure that the validation rule is in play. It was, each time.

[Welshgasman]

Might want to give the controls valid names, like I did.
6 months down the line Textxxxx is got going to mean much.

[sheckay]

Hello Welshgasman. Thank you for running that test. I'm not sure I can use that kind of a solution in the forms that the validation rules exist on. But it's interesting to learn about. However, even if that process runs fine with the .555 expected size and the .0002 tolerances, why do I not need a round function to get very similar values through the validation form? I know nobody has the answer to that know. But just the fact that this question can be asked, means that something isn't right. And I don't believe the point of failure is with the validation rule. If it was the other numbers wouldn't work. If rounding was a factor, it would affect them too.

[sheckay]

I was going to do that. But there are so many tables and fields in this database, that even the names I give them would not be of any functional use either.

[Welshgasman]

Well if you walk though your code, your should see what you are producing and comparing against? and why it complains one way or the other?
As CJ_London mentioned, could just be a rounding issue for certain numbers? I just picked 4 as that was the limit you were showing?

Good luck with it anyway.

[sheckay]

Thank you. I appreciate your efforts.

[sheckay]

I just created a test db. One table, with 4 fields. One form with 4 text boxes, connected to the fields. And I set up the same validation rule. Same outcome.

[Welshgasman]

I just created a test db. One table, with 4 fields. One form with 4 text boxes, connected to the fields. And I set up the same validation rule. Same outcome.

Put a Debug.print into your code with the variables you are using and some comment to see what is what, then review the output.

[sheckay]

Thank you Welshgasman. I've never done that. But I'll google it and see if I can put that in place. Thanks again.

Put a Debug.print into your code with the variables you are using and some comment to see what is what, then review the output.