Date Format Troubles

[CBragg]

Date Format Troubles - Please Help!!

Im having problems formatting Date() and Now() !!

To distribute the application im using Access Runtime 2000. In my code and a text box i use and have used:

Format(Now, "dddd")
Format(Date, "dddd")

Using Windows 2000 my application works fine, however when ive put the application on Windows XP it comes up with a run-time error. Ive narrowed it down to the 'Format' as it doesnt recognise it when opening a report. Ive checked the regional settings and also changed to US then back to UK.

Im very bemused as to why it works fine with 2000 but not with XP.

Any ideas on this would be greatly appreciated.

Thanks in advance!!

 

[Mile-O]

OPen a module, goto Tools -> References.

Anything MISSING?

 

[CBragg]

When ive copied the database all the references seem intact, i can't check them on the PC ive installed it on as im using Runtime 2000.

????

Its doing my nut in. It will even work on XP, but the majority of cases it wont. There must be something!

 

[Mile-O]

Format(Now, "dddd")
Format(Date, "dddd")

Was that just a typo?

Format(Now(), "dddd")
Format(Date(), "dddd")

 

[CBragg]

Sorry,

In a text box its:

Format(Now(), "dddd")

In the code its:

Format(Now, "dddd")

 

[Mile-O]

In my code and a text box i use and have used:

Format(Now, "dddd")
Format(Date, "dddd")

I know. That's why I mentioned the brackets.