Hi, Jimmy.
Quote:
access doesn't seem to recognize it as a valid date.
It works in the U.S. version of Access 2003, with both bound and unbound text
boxes, with both Date/Time and Text data types. Dates can be formatted
differently, depending upon the locality, but whether 1/1/2006 means January 1,
2006 or 1 January 2006 due to your settings, I can't think of why Access would
complain. Is it not a Jet table that this text box is bound to?
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact info.
"Jimmy" <none@none.comwrote in message
news:wEZih.86096$Ea5.45486@fe05.news.easynews.com. ..
Quote:
>
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SP AMwrote in
message news:_JGdnbabis4uxhHYnZ2dnUVZ_ruknZ2d@adelphia.com ...
Quote:
>Hi, Jimmy.
>>
>Set the text box's Default Value Property:
>>
>="1/1/" & Year(Date())
>
No can do. I tried this and the default value in the text box shows up as
1/1/2006 but access doesn't seem to recognize it as a valid date.
>
I used another suggestion...
>
=DateSerial(Year(Date()), 1, 1)
>
--
Rick Brandt, Microsoft Access MVP
>
which works great.
>
>
>
