$format parameter not working

[OwenHall]

I have tried to create a report which has a date formated to the a long date using "=Format$([Date],"Long Date")". But every time when the report is opened it asks for the $format parameter. I have used $format before on my Win98 pc, but since moving over to Win2k, I have had this problem. Can anyone give me advice on how to get around this problem.

 

[PHV]

Have you tried to use Format instead of Format$ ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[OwenHall]

I have, as I said it used to work on my win98 pc. I was thinking it might be something that I have to add, like dbase extensnions in Data Sources (ODBC)

 

[Crowley16]

can you give us more details on exactly where you are using this?

are you using this in code or as a format property or control source...?

 

[PHV]

Check for any MISSING reference in the VBA project:
Go to VBE (Alt-F11)
menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244