Date()

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

What happens when it doesn't work? Do you get an error message, or simply a
wrong value? Do you have anything else named Date on those forms? (i.e.: a
field name in the underlying recordset, a control name, a function in the
code, etc.)
 
in most of my forms, i use the date function as the
default value. howcome, in some forms they work and in
others not?
 
thanks for replying.

there's no error message, i just dont get a value. the
database im working on is very simple, the forms are
plainly used for data entry and i am very new to access so
theres no recordsets or any programming, functions etc.

before posting this reply, just to test, i added another
field on the table of date/time datatype and added it to
the same form where the date function is not working. i
set the default value to date(). guess what? it works this
time. really weird!

is it possible that its because the database was created
using an older version of access and now im using access
2003?
 
please disregard the 'experiment' i wrote on my other
reply. its not working! if the textbox is unbound, date()
works but if you chose a control source (the date/time
datatype field) from the underlying table it doesnt work
anymore.
 
Back
Top