Date formatting of text box not working with multiple users. 1

[Jables]

My report has a text box with the following formula in it.

=Format$([todaysdate],"Long Date",0,0)

When I run this report from my computer (the computer the database was created on), the report executes fine and the [todaysdate] field is formatted as such: Monday July 1, 2002.

Whenever I open this database on another machine on the network and try to run the report, Acess changes the text box formula from this:

=Format$([todaysdate],"Long Date",0,0)

To this:

=[Format$]([todaysdate],"Long Date",0,0)

The report can't run. It wants to know the parameter value for "Format$". So I opened the report in design view, and changed the text box formula back to its original state. I then saved the report and clicked the print-preview mode and Access changed the text box formula back to the incorrect formula.

This is my first venture in trying to run an access database from a server. Is there an easy fix to this glitch?

 

[NeeNee]

I have had similar problems with dates before. Try placing format charaters in the format property field for the text box displaying the date as opposed to using the format function.