ACC2000: "Expected: =" When ? Is Omitted in Immediate Window

ID: Q209930

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


SYMPTOMS

When you use the Immediate window to run a built-in or user-defined function that returns a value, if you don't type a question mark (?) at the beginning of the line, you may receive the following error message:

Expected: =


RESOLUTION

In the Immediate window, type a question mark before the function name when you run a function that returns a value.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. Press CTRL+G to open the Immediate Window.


  3. Type Date() in the Immediate window and press ENTER. Note that you receive the following error message.


    4. Compile error:
    Expected: =
  4. Repeat step 3, but this time type a question mark (?) at the beginning of the Date() function. Note that you receive results instead of an error message.


Additional query words: prb 


Keywords          : kberrmsg kbprg kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: May 17, 1999