Default Date in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was using the method Date() to bring up a default date. I since had to
move to another workstation and now all fields that should display today's
date now display NAME?

Can someone tell me what is causing this problem.

Thanks,
 
BobT said:
I was using the method Date() to bring up a default date. I since had to
move to another workstation and now all fields that should display today's
date now display NAME?

Can someone tell me what is causing this problem.

Dunno, but the first thing I would check is _References_. Open the module
window and on the menu, Tools | References. Look for any marked Missing,
uncheck them, close and reopen, and check again. You may have to add some
back in -- they may have been installed in a different path on that machine.
Or, you may have ended up with some extraneous references.

Larry Linson
Microsoft Access MVP
 
This is caused by the time/date format setting on your new workstation
computer. (I guess if you go back to your old workstation, the date should
be Ok). You have to change your workstation time/date to match the format
of your database. I am not remember how to go in and change the format,
contact your IT.

Else, change your database default value to =Now().
 
Back
Top