October 7, 200322 yr In this example, there are 10 fields. If data is entered into any one of the ten fields, the other nine fields are "locked" and data cannot be entered into any of them. Is there a way to accomplish this? This would solve a huge problem I'm experiencing. Thanks in advance!
October 7, 200322 yr Author That works! Thanks for the opening up the world of validation by calculation. Jason Goldsmith
October 7, 200322 yr You're welcome. You can add a calculation that turns the field's background to red so the users see that they cannot enter any value.
October 10, 200322 yr Author That sounds useful. How do you change the color of a field with a calculation?
Create an account or sign in to comment