Conditional formatting on a continuous form, based on another field.

[Craggy]

Basically i have a continuous form with a tick box and 2 text fields.

I would like to grey out the 2 text fields if the tick box is not ticked (indicating the record is not available)

I cant seem to find a way of basing conditional formatting on the state of a different field.

thanks

[missinglinq]

Select the fields to be formatted, goto

Format - Conditional Format

For Condition select Expression Is and in the criteria box put

[YourCheckBoxName] = False

then set your backcolor to whatever you want.

Welcome to TheScripts!

Linq ;0)>

[Craggy]

Select the fields to be formatted, goto

Format - Conditional Format

For Condition select Expression Is and in the criteria box put

[YourCheckBoxName] = False

then set your backcolor to whatever you want.

Welcome to TheScripts!

Linq ;0)>

Thanks.

I see now what the problem was. The fields i wanted to conditionally format were locked. for some reason this disables the conditional formatting.

oh well, ill just have them unlocked.

Thanks very much for your help :)

[missinglinq]

Glad we could help!

Linq ;0)>