Microsoft KB Archive/209930

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

Article ID: 209930

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209930



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to 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.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb. Press CTRL+G to open the Immediate Window. Type Date in the Immediate window and press ENTER. Note that you receive the following error message.

Compile error:

Expected: =

 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 kbprogramming kbprb KB209930

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.