Checkbox on a form

[Night Owl]

Hi,

I've got a form that is based on a table (but not a query). Several of the
fields are checkboxes, and although I've tried everything I can think of,
the checkboxes won't default to -1. I have to click once to clear it of
'grey' and then again to put a tick in the box.

TIA,

Pete

 

[Arvin Meyer [MVP]]

Check boxes are Null when the form is first opened, unless the DefaultValue
property is set. Try using True and False.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Night Owl]

Thanks Arvin, but would you mind clarifying, please?

The table the form is based on is a linked Excel spreadsheet. I've set the
default value in the table to False, but it doesn't save it (which I
understand) but even setting the checkbox default value to 'False' gives the
same results. Would this be because the records were there before I made
the change, and new records will be set to False?

Thanks,

Pete

 

[Arvin Meyer [MVP]]

You cannot set the DefaultValue property of a linked table, nor is there
such a property for an Excel table. You can set the checkbox value in a form
as the DefaultValue property of the form control. Existing records do not
have a default value. You'll either need to change them manuallu or use an
Update query.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Night Owl]

OK, I understand that. If I set the Update query to run when I open the
form, wouldn't that change all the existing records as well, or have I lost
the plot? I think I may have to my users to do this manually :-(

Pete

 

[Arvin Meyer [MVP]]

Typically, you would run the update query only once. If you use criteria
with the Update query you can narrow the results to just the ones you want
to update.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access