
FORMAT function doesn't work in Access 97
The very simple FORMAT$ and FORMAT function doesn't work in Access 97. For example, the following function returns an error code when compiling the module:
txtDate = Format(Now(), "mm/dd/yy")
or
txtDate = Format$(Now(), "mm/dd/yy")
I get an error message:
Compile Error. Cannot find object or library.
Any thoughts???
Responses via email are appreciated.
Your help is appreciated. Thank you in advance.
John