Yes/No field on form does not change when clicked

[mdavid]

Hi I have a Yes/No field in a table (Formated Yes/No) I dragged it onto a form. Problem is when I click it in Form View there is no change, I expected it to toggle between tick and blank. What am I doing wrong?

Thanks


David

[pbaldy]

Is the form bound to that table? Sounds like it may be read only.

[mdavid]

Thanks Paul, You're quite right it is read only. I want this table to be read only, but I also need to be able to use the Yes/No field, that is all fields except the Yes/No field should be read only, is this possible?

Thanks
David

[pbaldy]

One way would be for the form to allow edits, but lock all the controls except this one.

[mdavid]

Yes was just playing around with that, set Enabled to No, has the same effect, what's the difference between Enabled and Locked?

[pbaldy]

Locked still lets you click in the control, setting enabled to no does not (and it grays out the control).