Record insert makes checkboxes default to true - after Office upda

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access ADP file that I've been using for about 4 years now
constantly making updates and expanding the functionality of my application.
I use the Access 2003 developer extensions to compile the ADP into an
executable and package the Access Runtime.

I recently applied a BUNCH of Windows and Office updates and since then
every time users insert a new record most all the fields checkbox fields (but
not all) default to being checked. I was way behind in my updates so it
could be an older update or a new one that caused the problem. I also
applied MsOffice SP3.

The record source to the form is a view. I checked all the fields in the
database and they're all set to default to (0). I checked the checkbox
definitions on the form and they're all set to DEFAULT VALUE False.

I can't figure out why some are defaulting to being check and some aren't
especially since they're all defined the same way. I stepped through the
code and there's nothing setting the values - they're being set when the
record is inserted.

Has anyone seen this or have a workaround?

Thanks

Guy
 
Are you relying on Access to initialize them or are you specifically
initializing them yourself?

-Dorian
 
I'm not clear on what you're asking but I have the checkboxes ALL defined as
defaulting to 0 (false) at the database level and at the control level within
the ADP.

As I mentioned, the ADP has been working flawlessly for 4 years but after
the MsOffice SP3 update SOME of the checkboxes automatically become checked
when I create a new record. Strangely, some don't. I systematically stepped
through the code to make sure there was nothing setting these values on the
form but there is nothing. I compared the checkbox controls that are getting
checked to ones that aren't and I see nothing different between them. I'm
baffled.

Guy
 
I'm not clear on what you're asking but I have thecheckboxesALL defined as
defaulting to 0 (false) at the database level and at the control level within
the ADP.

As I mentioned, the ADP has been working flawlessly for 4 years but after
the MsOffice SP3 update SOME of thecheckboxesautomatically become checked
when I create a newrecord. Strangely, some don't. I systematically stepped
through the code to make sure there was nothing setting these values on the
form but there is nothing. I compared the checkbox controls that are getting
checked to ones that aren't and I see nothing different between them. I'm
baffled.

Guy





- Show quoted text -
Click to expand...

I'm having the same exact issue with my Access 2003 adp. I also
recently applied Office SP3. I haven't tried troubleshooting it yet,
but I figured it must have had something to do with the service pack
since nothing changed in the adp. The form is bound to a view in SQL
Server 2005, and the table columns have bit data type with defaults of
0. Default values on the checkboxes on the form are False.

I had some other issues when SP3 was installed which I have since
corrected, so I'm not too suprised to find this one. It just took a
little longer for me to notice.

Joe
 
This is an often reported bug with SP3, and yes, I've seen reports of it not
being consistent. What I haven't seen on this particular bug is any work
around! Sorry!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top