Default value in checkbox changes when entering new line

**PianoMan64** · Mar 20 '08, 06:53 AM

I'm assuming from what you've wrote that since you've mentioned the SQL Word, that you're either using MS SQL or some other SQL Backend other than MS Access? If that is true. you need to change the table definition to Integer with a value of 0 for false and -1 for the value of true. anything else will always evaluate to true. This is why you're getting the checked box, because access is evaluating the value in the Bit field as true. Just change the field type from Bit to Integer and change the value to 0 for false.

**gurge** · Mar 26 '08, 08:22 AM

Hi!

Sorry for the late reply... Just managed to get back on this task again.
I totally understand what you mean and thank you for explaining it to me. Yes, I am using MS SQL.

I tried doing what you said and changed that column from bit to smallint (am i right?) however, I dont know how to default 0 to false as you said (I am using MS SQL Management Studio) Or is it done using SQL code?

appreciate the help! thanks ;)

**FishVal** · Mar 26 '08, 01:10 PM

Originally posted by gurge

......
So what I have done is to set the default value to False (have tried 0 as well)
and in the bottom row (the add new line row) this box is shown to be unchecked.

But once I key in any data in the row, the checkbox immediately auto checks itself.
......

Are you sure there is no code running on Current event in the form?

**gurge** · Mar 28 '08, 07:21 AM

Hi all...

Seems after a TON of googling, my issue was exactly this:

http://thesource.ofallevil.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access.adp.sqlserver&tid=dd741a32-bf63-4620-94fd-5d2d125bb699&cat=en_US_f66f8646-217e-4f1a-bb45-d9d57b41d9d9&lang=en&cr=US&sloc=&p=1

after a hotfix, it works fine now.

Thanks alot for all the help ;)

**Fiddler2** · Mar 28 '08, 08:02 AM

Originally posted by gurge

Hi all...

Seems after a TON of googling, my issue was exactly this:

http://thesource.ofallevil.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.access.adp.sqlserver&tid=dd741a32-bf63-4620-94fd-5d2d125bb699&cat=en_US_f66f8646-217e-4f1a-bb45-d9d57b41d9d9&lang=en&cr=US&sloc=&p=1

after a hotfix, it works fine now.

Thanks alot for all the help ;)

Hey, your link didn't work and I'm really curious about this. Would you mind explaining the gist of it?

**gurge** · Mar 28 '08, 08:13 AM

Hmm yea... its kind of a weird URL...(funny as well) the site is actually the microsoft forums tho.

Hope its okay to copy and paste what it said...

I have Access 2003 and SQL Server 2000. Lately I noticed when I add a new
record, all of the bit (check box) feilds deault to True instead of False. i
have made sure w/i Enterprise Manager the defualt is 0, I also did this with
in Access, property
field default value to 0. I did some research and one reply on
Microsoft.publi c.access was that this is a known bug that has been introdued
by 2003 sP3 and MS is aware if this problem. Do you know if this problem has
been fixed? How do I determine that? (I tried looking for a fix) Does anyone
know of a work around?

Below is the website where I found the response. http://groups.google.com/group/micro.../browse_thread
/thread/474a73bca0883a1 5/cfe98fa5112528f a?lnk=st&q=acce ss+sp3+adp+bit& rnum=9

Thanks
ToniS

Answer

Toni,
Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007

Error - Office.com - Microsoft Support

http://support.microsoft.com/kb/945674

Jeanette Cunningham

Its basically due to the combi of having Office 03 and SP3. and Microsoft has recognised this problem:

Error - Office.com - Microsoft Support

http://support.microsoft.com/kb/945674

and created a hotfix for it.

Do let me know asap if its NOT okay to copy the other forum's thread here. :)

Hope this helped anyone!