Office Engine doesn't recognize 'Format'

[chanman525]

Hey all. I just got Office 07 installed and I'm running a database that ran fine in 03. When I run it, I'm getting an error saying "The Microsoft Office Access Database Engine does not recognize 'Format' as a valid field name or expression"

It shows it as Error 2950

I view the report that it errors out on, and I have a text box showing

=Format(Date(),"Long Date") & " " & Format(Time(),"Long Time")

What would I need to change this to in order for it to work correctly? Thanks all, I really appreciate it.

 

[PWise]

Check for missing refrances

 

[SkipVought]

Hi,

What about
[tt]
Format(Now(), "dddd, mmmm dd, yyyy hh:nn:ss")
[/tt]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[chanman525]

Missing reference. Didn't think about it. Thanks pwise.