Why won't =format([InWeek],"ddd") work in my report

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

I just made a small database in Access 2002. I have a report where I
want to add a field with the control source as:
=format([InWeek],"ddd")

[InWeek] is a field in the recordsource. I tried not having the field
on the report and I tried putting it on the report as invisible.

But when I enter the above expression into a text box, it says "There
is an error compiling this function"

I have done similar things in Access 97 databases. Am I missing a
reference to a library or something?
Thanks
 
Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Open your VB Code page, select Tools | References and make sure that the
Visual Basic For Applications reference is checked and in at least the
third position from the top. Use the Priority buttons on the left to move
it up.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top