Check boxes wont save

A

Angel_1

Hi, i have a table with a few check box fields in but they dont save and i
have to choose the check box option for each field every time i open the
database, any clues please?
Also the rows and column heights wont save to what i put them at.
Thanks
 
A

Angel_1

Hi
Yes, sorry, its the table i am working with, i am not using a form for this.
Thanks
 
B

BruceM

You shouldn't be working directly in the table. You can use autoform to
create a quick form. If you have a single table and wish to work directly
in the table, a spreadsheet would be a good choice.
When you say the check box fields don't save, do you mean that you create a
record and check the box in some yes/no fields, but when you go back to that
same record those fields are no longer checked? Or do you mean that you
want the default for the yes/no fields to be Yes?
 
A

Angel_1

Hi
I select check box in the design layout and the field shows the box but when
i come to reopen the database the field shows either a -1 or 0 depending on
if i've checked them. so i have to reselect the check box in the design
layout.
 
A

Angel_1

Hi
Yes, thats what i mean, i choose Yes / No in Data Type, then i choose Check
Box in Display control, Press Save, Close table, when i reopen it none of the
above has been saved.
 
B

BruceM

It's definitely a table and not a query?

If it's a table, you could try exporting it to a new blank database.
However, using a form instead of a table for data entry would be best.
 
A

Angel_1

Yep defininatley a table. I have now added a check box to the form and that
seems to be working but the table is still not saving the check boxes.
Thanks for your help
 
B

BruceM

A Yes/No field stores a number value. As long as it is storing a -1 or a 0,
no problem; a check box bound to the field will show the correct value. I
can't explain why you aren't seeing the check boxes in the table. You could
try exporting everything to a new blank database: Create a new database
file, then click File > Get external data > Import. Navigate to your old
database, and select the tables, forms, etc. You could also try Tools >
Database Utilites > Compact and Repair on your existing database. If you
create a new table, does the same thing (i.e. no check box) occur with
Yes/No fields? How about if you copy the table, paste Structure Only (click
Paste; you will see the option), and add new test records? Or if you do the
same thing, but paste the data and the structure? Does this happen in every
database file, or just this one? Time for some detective work.
 
A

Angel_1

Hi
It only seems to happen in this database. Its took me so long and so many
posts to get it just right i think i will leave it as it is, at least i can
use the form to check the check boxes.
I do however have another question...
I have another database which i has a combo box and a tab control page on
it. The combo works fine showing only records that have been chosen by it.
Only problem is i would like the form to open showing no records until the
combo has chosen. Any ideas please? I really appreciate the help.
 
B

BruceM

If it is only happening in the one database you may do well to follow one of
my suggestions about exporting to a new database, performing compact and
repair, and so forth. You have given no indication that you have considered
or tried the suggestions.
For the current question, you could open the form to a new record, which
would show a blank form (unless there are default values). Another option
would be to put controls bound to fields into the detail section, then open
the form with the Detail section's visible property set to False. The After
Update event for the combo box could set the Detail's visible property to
True. After that it would be visible as long as the form remains open. You
could also use an unbound form to select the criteria, and open your form
using those criteria. This last option would probably be best if you do not
mean to select from a combo box to filter the records after the form is open
(i.e. conduct a series of selections). The approach depends on just what
you need to do.
 
A

Angel_1

Hi Sorry it took so long to reply, i exported everything to a new database
and everything now works fine. thanks for your help
 
Top