"Format" function in Access XP vs. Access 2000

[ag90fox]

I ported a database from Access 2000 to Access XP. In trying to run a report based upon a query that has the statement ' DateNow: Format(Now(),"mmmm dd" & ", " & "yyyy") ' as one of the fields it is telling me that "format" is an undefined function. This works in Access 2000, but is there a similar function in Access XP.

Thxs.

 

[BobJacksonNCI]

With VBA module open, check Tools / References to see if Visual Basic for Applications is checked - needs to be.



HTH,
Bob