Check Box issues

[George Too]

Hi all,
I have a couple of check boxes in one of my forms. I set their default value to =1. The problem is that when the form opens my code does not see the box as being checked untill I recheck the box. Why isn't Access seeing it checked?

Thanks,
George

 

[Mile-O]

Is the checkbox bound to a field?

If it is, the field it's bound to could already be set to 0 and that might be why.

 

[George Too]

Thanks all for your replies,
The check boxes are not bound. I use them as user options to print the report that is being generated. If the check box is checked (default value) then the report will be printed after being created. Else, it won't print. No records are created in this case; it's just manipulation of records and reports.

George.

 

[WayneRyan]

George,

-1 = True
0 = False

Wayne

 

[George Too]

Thanks Wayne, but I also try those values (they were the first I tried) and still I have to "reclick" my boxes to make them true to Access otherwise it won't see them as checked.

Again, thanks for your time. Do you have any other ideas?

George

 

[Oldsoftboss]

As a "Give Up" solution put a bit of code on the OnOpen event of the form

Me.CheckBox = -1

Might work???
Dave