I have a field in my database that

[InsaneProgrammer]

I have a field in my database that defaults to todays date. I use =Date() in the fields default value. The field has not had any problems since I created this database 9 months ago. All of a sudden the field began displaying #Name? when you go to a new record. As soon as you type something it goes away and correctly shows the date. I haven't changed anything in the database. Does anyone have an idea on how to fix this? If I use Now() the problem goes away but I don't want the time. The time screws up all of my queries and reports.

 

[JerryDennison]

You can always set it =Format(Now(), "Short Date&quot

Also look at your References. See if any are marked *MISSING*.

 

[InsaneProgrammer]

I used =Format(Now(), "Short Date&quot as you suggested and it caused an error. I had to take out the = sign. After that it still displayed #Name?. I looked at the References and none are missing.

 

[tombirch]

I have experienced the same problem sometimes. And usually the problem seems to have occured because of an error somewhere else in the code. So maybe you have an error somewhere in your code. Try to compile your code first.

 

[ghubbell]

Here's another choice for all to test:
Control Source or Default Value: =Now()
Format: Short Date
worth a try....! Gord
ghubbell@total.net

 

[RickSpr]

Also, check for name collisions. Especially, if you have a control named Date, change it to something else.

I tended to have this sort of problem when I used field names as control names, most commonly naming a control Name. Nowadays I always use a control name prefix that identifies the type of control. It makes the code easier to follow, too. Rick Sprague