Check Box Problem

[Eljefegeneo]

I have added a check box to my back end and when I display the datasheet it shows up as a check box. However, when I add it to my form on the front end, it shows up as text. The properties are exactly the same as any other check box in the table. I do have a number of check boxes in the tale and I was wondering if I exceeded some limit. But I cannot find any reference to a limit on check boxes.

Does anyone know why this might be happening and/or a solution? I have deleted the field and added it back on several times with different names. :banghead:

 

[Eljefegeneo]

OK, I just figured out a "work around", add a unbound check box and the bind it. But it still doesn't make any sense to me why this is happening.

 

[zeomkean]

I am not sure on what you are trying to do. But if you are locking controls using VBA then you will not see this in the properties of the form. If you run the form & the VBA you should be able to see if the controls are locked.



________________
ahsan

 

[Eljefegeneo]

No, there isn't any VBA yet attached to the check box when I add it to the form. It has exactly the same properties as other check boxes, t/f; checkbox. But when I try to add it to the form, it appears as a text box.