Checkbox on a form

  • Thread starter Thread starter Night Owl
  • Start date Start date
N

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
 
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
 
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
 
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
 
Back
Top