Hello all, rather new to Access.
So I have a subform where the user is supposed to put the length of the object he is checking. Most of these items have a tolerance, and they all vary by size.
We have over 100 different items, I been using the Conditional Formatting but I did not know it had a limit of only 50 conditions.
This is the condition I used
Code:
(Right([Forms]![main test]![Part#],3)="813" And [length]<31.5) Or (Right([Forms]![main test]![Part#],3)="813" And [length]>32.5)
Each part has it's size in it's name in millimeters, that's the 813mm. If the object is out of bounds, the text color should change to red.
So I tried doing this in code builder but I think I'm doing something wrong as the text color isn't changing.
This is what I used, only did one as an example to see if it makes the changes but it doesn't.
Code:
If (Right([Forms]![main test]![Part#], 4) = "1320" And Me.length < 51.45) Or (Right([Forms]![main test]![Part#], 4) = "1320" And Me.length > 52.45) Then Me.length.ForeColor = vbRed
End If
I put this in the textbox length, in the afterUpdate() section of the Data tab.
Thank you in advance.