Checkbox on a form


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
 
Ad

Advertisements

N

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
 
A

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
 
N

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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top