'Greying-out' a field etc.

[wglmb]

Is there any way I can 'grey-out' (not allowing people to type is the most importent thing here, but the turning grey would be useful too) a field if (for example) a check-box isn't selected?

 

[astarbyfar]

Conditional formatting

Yes there is a way. If you have a check box (which I will call checkbox1), then in the afterupdate() event type the following;

If checkbox = True Then
' This will allow the user to enter information
Me.textarea.enabled = true
Me.textarea.backcolor = vbwhite

Else
'This will permit the user from entering information and will produce a grey like backcolor
Me.textarea.enabled = false

End If

Hope this helps by the way the text area is the area which you wish to enter information.

If I havent explained this well enough post the db and I'll show you and give full comments

 

[wglmb]

Thanks; that's very helpful