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
SteveL13Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GRayLCommented:
Are you saying the Control Source property of the text box is:
=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.
0
SteveL13Author Commented:
It is not the control source.  It is an unbound field.  I've tried both =Date() and Date() and still have the same problem.
0
SteveL13Author Commented:
(In the default value)
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Gustav BrockCIOCommented:
Sounds like a reference is MISSING.
Look up menu Tools, References and sort out any MISSING reference.

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
Set the Default value in the Table, not the Form...

This works fine for me in Acc2003/Acc2010
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.