Making Yes/No field set to 'Yes' if next field contains text

[d.silverman]

Hi - I expect this is either easy or obviously not possible, but here's my basic question:

I want to make a Yes/No field automatically set to Yes when the next field contains any text.. I am inputting questionnaire responses where there is a question like "do blah have any advantages, if so what are they?". If people have given a response listing advantages, I also want a check box field in Access denoting that they do think there are advantages. I don't want to use a query, rather I want the check box to check itself whenever data is entered in the text field.

Possible? Thanks in advance

 

[SydneyGeek]

Re: Making Yes/No field set to 'Yes' if next field contains

You could try using some event code on the Advantages field.
Select this field in Design view, click the Properties, then the Events tab.
Double-click in the blank line for After Update. You'll see [Event Procedure].
Click the Builder (...) button to view the code window.
Enter this code:

If Len([Avantages].Text)>0 Then
   [MyCheckBox]=True
Else
   [MyCheckBox]=False
End If

Change the names of the controls (in square brackets) to suit.

Denis