Getting a check box to enter a value of yes or no in a table

[MattBegg]

I have several forms with check boxes and I would like it that when the check box is clear a value of "no" for that field is entered into the table and if checked then a value of "yes would be entered into the field.

I managed it in a non repetative way by originally having the fields in the table set as yes/no and when the data had been entered into the table I changed the field to text and this produced the desired effect. Obviously this is not the way to go about it.

Any help out there would be greatly appreciated Regards

Matt

matt@begg-uk.co.uk

 

[mfulton]

You can create a query with an expression field that reads something like this....

exp:IIF([nameofcheckboxfield]=1,"yes","no&quot this translates to-- IF the checkbox field holds the value of yes (1), then put the word yes in the expression field, else put no in the expression field.--

You can then use the expression field in the report or form. Michelle Fulton