=Format(Date(),"yyyy") 1

[JimWho]

I've been upgraded to Office 2003. I also made sure I have the usual references in VBA. My report puts the year in the title (in header) using the formula shown in the subject line of this message. For some reason it is now not working. When I open the report it asks for Format? and then Date?, so I enter enter twice and see #Name in the title.

What am I missing that =Format(Date(),"yyyy") does not now work?

 

[GingerR]

Make sure you have no MISSING references

faq181-936

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html