Preventing entry in a field

[gaby78]

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.

[Zero Tolerence]

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

[gaby78]

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.

[mr_vodka]

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

[gaby78]

Thanks for your help, that solved the problem.

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

Thanks

[Søren Dyhr]

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

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

--sd

OhoyLockKeeper.zip