I am having a problem with check boxes on forms.

If the box is checked, I can un-check it with no problem.

However, if I try to check an un-checked box, I get an error dialog box which says that I am trying to put more data into a field than it can hold and to try to insert less data.

What gives?

Is there a fix?

Rand

__________________
Rand

We need a little more background about how you created the checkboxes.

For example, if they are part of an option group (where checking one checkbox UNchecks the others automatically), then the checkbox states (assuming triple state property is set to NO) are either TRUE or FALSE. However, the option group value is equal to the checkbox number which you clicked TRUE. Therefore, if you clicked the second checkbox, the option group value is 2, etc.

Could it be you're trying to code something and instead of giving the option group a value of 1, 2, 3, etc. you're trying to assign this number to a checkbox itself?

You get the idea... we need to know more about your form structure and when this error occurs.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

It's OK! I found the problem.

Somehow, when the data was imported from SQL Server, the boolean fields got converted into single character text fields.

All I had to do was to convert the fields into boolean data type (True/False, Yes/No, On/Off values).

Rand