$ Format parameter request

[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.

 

[lupins46]

Why don't you just use the format property of the textbox instead?

 

[OwenHall]

Thats what I am doing at the moment, but I was curious as to how "format$" worked on Windows 98 and not Windows 2000. I thought someone may have an answer as to how to get it working under the Windows 2000 operating system.

 

[Craig0201]

Post the SQL so it can be checked, please.

Craig

 

[PHV]

Have you checked the VBA references ?
Have you tried 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've tried different variations on the format front but to no avail. What should I check in my references?

 

[PHV]

While in VBE, menu Tools --> References...
You may consider to compile the whole project.

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