Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Undefined function 'Format' error (Access2003)

    I've created a Crosstab Query that has a field that is as follows: Expr1: Format([OrderDate],"Short Date")
    Problem is, on one computer, no errors appear when running the query. On another computer with same version of Access, the following error comes up when trying to run the query: Undefined function "Format" in expression . Thanks in advance to anyone with a possible solution. BW

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Undefined function 'Format' error (Access2003)

    The machine that receives that message probably has a broken reference. In the VBE, go to the Tools menus and select References. That will bring up a list of references. If any of them show a MISSING: instead of a checkbox, try unchecking that reference and see if the project will compile.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •