Default Date Problem

Last September, I added a field in an existing table and set the default to
"Date()". It worked fine when i added records to the table or with a form.

The other day I had too much time on my hands, and changed the
tools>options>general>4-year format choice. This may have caused problems.

Now, when I click the form's ">*" (end of file +1) to add an new record,
MSACESS.EXE crashes. If I remove the field's "Date ()" default, the new
record can be added. As a test, if I add a new field in the table (thinking
that the old field was corrupted somehow) and to the form, the new field
with its Date() causes a crash. There is no problem when a new record is
added to the table directly.

Any thoughts? Using latest and greatest Access.
.

Relevant Pages

  • Re: Up On One
    ... > The crashes are pretty cool. ... No such thing as a pretty cool crash. ... 2006 FLHTCI ... Prev by Date: ...
    (rec.motorcycles.harley)
  • Re: VB6 app crashes on XP
    ... > Hi Jan - I don't know yet the specific line where it crashes but it ... We can go 'round and 'round but, ... "crash" and tell us the exact error messages/numbers you're getting, ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: Shell function return values
    ... > because VB crashes when it happens ... VB does NOT crash! ... It reports a error and then terminates as it can't ... Prev by Date: ...
    (microsoft.public.vb.winapi)
  • Re: regsvr32 CRASH
    ... > can build it in debug or release mode and it diesn't crash. ... describe what happens when regsvr32 "crashes"? ... Prev by Date: ...
    (microsoft.public.win32.programmer.ole)
  • Re: What to do when Word constantly crashes?
    ... crash", but I use them all day every day (I am a professional Technical ... Microsoft was one of the first to realise that being "The first to be wrong" ...  Keep the updates up to date. ...  Your crashes should stop! ...
    (microsoft.public.mac.office.word)
Loading