Problem with date field
I have a database I've developed over the years using Access 2003. The company I developed it for is still using 2003. On a form in the database I have a text box with a default value of =Date(). When the form is launched with 2003 the field has today's date filled in which is exactly how I want it to work. This form also works fine on my computer using Access 2010. But now when I make an alteration to the Front end database which contains the form in question using my Access 2010 version and upload it to my customers computer system, which is still using 2003, the field gets populated with "#Name?" instead of today's date. Why is this happening?
--Steve
--Steve
ASKER
It is not the control source. It is an unbound field. I've tried both =Date() and Date() and still have the same problem.
ASKER
(In the default value)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Set the Default value in the Table, not the Form...
This works fine for me in Acc2003/Acc2010
This works fine for me in Acc2003/Acc2010
RE: "But now when I make an alteration to the Front end database which contains the form in question using my Access 2010 version and upload it to my customers computer system, which is still using 2003"
Steve ... are you saying that ... you are modifying the A2003 MDB in the A2010 environment, then uploading to back to an A2003 environment. If so, there have been several reported issues with this scenario, even though in *theory* ... if you do *not* use any new features of A2010 on the MDB (which DO show in the property sheets - even though it's still an mdb) ... you can do this, it's apparently can be problematic. However, as Gustav notes ... high probability of a Reference issue.
mx
Steve ... are you saying that ... you are modifying the A2003 MDB in the A2010 environment, then uploading to back to an A2003 environment. If so, there have been several reported issues with this scenario, even though in *theory* ... if you do *not* use any new features of A2010 on the MDB (which DO show in the property sheets - even though it's still an mdb) ... you can do this, it's apparently can be problematic. However, as Gustav notes ... high probability of a Reference issue.
mx
=Date()
To set the Default property, do not use the equal sign. Although A2003 text box will accept both =Date() and Date() as Default values, most probably A2010 will not.