chech box and adp

[ringo]

I've a chech box in the form.

The form is associated with a recordset that derives from store procedure.

I use Access 2002 and if I click on the check box access go in crash

How can I resolve the problem?

thanks and regards

ringo

 

[J. Clay]

Unfortunately, I don't believe there is a resolution to this. I posted
several questions regarding this over a year ago to no avail. The biggest
problem is that it is not consistent. Some check boxes will work fine and
others will crash the app. I recall seeing somewhere that it had to do with
BIT fields, but I have not been able to confirm this. I have noticed
lately, that it has not been happening as often. (Who Knows????????) I
have in the past, deleted the check box, compact & repaird the app and then
recreated the check box. Also, I have used code to control check boxes to
get around people actually clicking on them.

Jim

 

[Sylvain Lafontaine]

You may try Access 2003; as it solve many of these small bugs. Personaly, I
had the same problem with checkbox under Access 2002.

You can also try to unlink your checkbox and have code that will set their
states on entering and on leaving the current record. However, this will
not work with continuous forms.

S. L.

 

[Antonio Ortiz]

no problem with my Access 2000.

Define fields like "Int" instead of "bit"

Antonio Ortiz Ramirez
asesor en sistemas
ant(a)aortiz.net
www.aortiz.net
www.progvisual.com