enable and disable fields based on text input

[murray83]

here is my code so far which works in a fashion

the field "Status" is defaulted to Waiting so people can see how many tasks are waiting but in this situation it allows you to change the status without entreing a name

but if you delete the status it does work once in this example you type in kev

so i have two questions

1, im not going to be able to type in evrey name so is there a function i can put in place of "kev" which will work ie a string of characters

2, how do i make it work if possible even with a default value

see attached also

   ' by default enable status
    Me.Status.Enabled = False
   

    ' test the value entered by user in the category field and hide fields as required
    Select Case Me.ActionedBy
        Case "kev"
            ' if the user has entered a name then unlock status
            Me.Status.Enabled = True
    End Select

 

[sneuberg]

You could disable the Status field by adding another conditional formatting rule like:

The only thing is that the user will have to know that he will have to move the focus from the ActionedBy field before the Status would be enabled. This would work better if you could move the ActionBy field to the left before the StartTime.