Change Check Box if Data Present

[fenhow]

Hi,

Is there a way to change the value of a check box when data is added to a field automaticlly?

Default state of the chkBox is unchecked, default state of field is null. If I add anything to the field I want the chkBox to be checked..

Thanks.

Fen How

 

[pbaldy]

It sounds like the checkbox is unnecessary, since you can simply check the state of the field. I wouldn't have it. In any case, in the update event of the control:

If Nz(Me.ControlName, "") = "" Then
  Me.Checkbox = False
Else
  Me.Checkbox = True
End If

 

[fenhow]

Thanks Paul.

Fen

 

[fenhow]

Hi, sorry in the before update or after update and does this go in the checkbox or the field that will change triggering the change?

Fen

 

[pbaldy]

After update of the field triggering the change. But I still wouldn't have the checkbox.