Discussion Locked

MS Access 2000 Expression Builder

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

While using Access97 I became comfortable using the expression builder when building code statements in VBA to obtain the proper syntax for form and sub form field properties and methods.

I have now been using Access 2000 and when in VBA I cannot find a way to open the expression builder from within VBA.

Is there a way to open expression builder in Access 2000 VBA?

If not, Is there an easy way to obtain the proper syntax when selecting form fields and properties in VBA.

4 replies

by nikki96

From Access help menu...
(bring up help, then type "expression builder")

Start the Expression Builder in the query design grid or a macro condition
You can start the Expression Builder in a Field or Criteria cell in query Design view or in the Condition column of the Macro window.

Right-click where you want to insert the expression.

On the shortcut menu, click Build.
Note If the cell or Condition column where you start the Expression Builder already contains a value, that value is automatically copied into the expression box.

HTH
Nikki

by ldufresne19

Nicki,
Are you stating I should build the statements i wish to use inside access 2000, Query using Expression builder and then cut and paste them to my VBA code?

This discussion is closed to new replies.