Green Check Box?

[lacey]

This may seem like a silly question, but I know little to nothing about Access so here I go:

I have a form used for registration. One of the elements in the form is a check box to identify whether or not that particular registration was canceled. I have used this form for a very long time, but now, out of the blue, the unchecked check boxes are filled with a green square, and the only way to do away with them seems to be to click on it twice.

I am also having the same problem in a different database's form.

As I said, sounds like a silly question, but I'm not too proud to ask for help

 

[ghudson]

Sounds like your check box is corrupted. Try deleting it and recreating it in your form if the check box is correctly bound to a field in your table/query.

 

[boblarson]

Well, that would be a NULL checkbox, so neither yes or no. If it is not a bound checkbox then you would want to set the values on Form Load to false.

 

[vbaInet]

1. Go to the Property Sheet for that check box in design view
2. Select the Data tab and change the Triple State property to No.

That may be the problem.

 

[boblarson]

Or it could be that the checkbox's TRIPLE STATE might have been set to YES. (just another thing to check)

 

[boblarson]

 

[lacey]

Sounds like your check box is corrupted. Try deleting it and recreating it in your form if the check box is correctly bound to a field in your table/query.

Tried it, didn't work...

 

[lacey]

@boblarson,

Not sure how to do either of those... can you help?

 

[boblarson]

In the VBA Window for the form load event (open the form in design view, go to the properties dialog, find the events tab and click on the LOAD event listed and select [EVENT PROCEDURE] from the list and then click the ellipsis (...) to the right of that dropdown.

Put this code in between the Private Sub Form_Load() and End Sub:

If IsNull(Me.YourCheckboxNameHere) Then
   Me.YourCheckBoxNameHere = False
End If

Me.YourCheckBoxNameHere.

make sure you replace the YourCheckBoxNameHere part with the name of your actual checkbox. The ME part you leave exactly as is with the dot after it.

 

[lacey]

In the VBA Window for the form load event (open the form in design view, go to the properties dialog, find the events tab and click on the LOAD event listed and select [EVENT PROCEDURE] from the list and then click the ellipsis (...) to the right of that dropdown.

Put this code in between the Private Sub Form_Load() and End Sub:

If IsNull(Me.YourCheckboxNameHere) Then
   Me.YourCheckBoxNameHere = False
End If

Me.YourCheckBoxNameHere.

make sure you replace the YourCheckBoxNameHere part with the name of your actual checkbox. The ME part you leave exactly as is with the dot after it.

Thanks for the suggestion, but that didn't seem to fix the problem at all. Any other ideas?

 

[vbaInet]

Did you try what I suggested in my first post? Post #4?

 

[lacey]

I did, but they were already set to "No"

 

[vbaInet]

I think this is more of a Type Face problem. Can you post a stripped down version of your db for us to look at?

 

[lacey]

Classic newbie statement: I'm not sure how that's done!

 

[vbaInet]

At the bottom of the box you use to reply to a message, Click Go Advance and you will see Manage Attachments.

Remember to zip and explain what to do to replicate the problem.

 

[lacey]

Okay... hope I'm doing this right. Under the "categories" tab on the form, you can see all the check boxes are green.

 

[vbaInet]

When you move through records do some of them get ticked?

 

[lacey]

The only ones that are ticked are the ones that I have already ticked when entering the records. If I don't tick them, they stay green. If I untick them, they are empty.

 

[vbaInet]

That's default behaviour, there's nothing wrong with the check boxes.

Your table contains lots of Null values. That is it's "empty" so it will turn green. If you check it and uncheck it the value that will be saved in the table is 0. So if you want all the empty boxes you need to change the datatype to Yes/No.

By the way look up the term "normalise" because your db seriously needs it.

 

[SOS]

Your problem is that you should have the default for those fields be 0 (or FALSE) because that is the issue. They are null and not yes or no. If they are null they will show like they are. If you don't want them to be null then run an update query to change your current records to 0 where they are null and then add a default value of 0 to the field.