Hi all:

How to prevent entry in a field under certain conditions

I have 2 fields: Status and Commissions. How can I prevent the user from entering the Commissions field if the Status field contains the code F. I used a validation rule for the Commissions field but users can still force data into it. I want same effect as if the field was formated not to be entered in Browse mode.

Any suggestion will be highly appreciated.

Well, you can use Validation by a calc and make it give them an error if it has anything but "" in it.

That's what I currently have. The problem is you can still enter data if you click Yes on the message box. I want the field not to be enterable at all.

In your field definition, under Validate, turn off the option for 'allow user to override during data entry'

Thanks for your help, that solved the problem.

Just out of curiosity, can you achieve the same results with a script.

Thanks

There's another option, where you combine The Visibility Trick

with a mergefield that begins just outside the portal...

--sd

OhoyLockKeeper.zip