FORMAT and TRIM functions

[Georgews]

Has anybody had any problems with these in Access XP? I can type what was a valid expression in 2000 but XP won't accept it. e.g. format([mydate],"mmm&quot worked in 2000 but not in XP.

Also if I use the Label Wizard it brings up a parameter box with the word "Trim" in it indicating that it is not recognised. I go to the design view of the labels and delete the word Trim and all is well.

Any ideas?

Thanks guys

 

[tlbroadbent]

You probably need to fix the library references. Check this link.

http://support.microsoft.com/support/kb/articles/Q283/8/06.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Georgews]

Thanks TLB - works now
George