Here's the MS Help on how to start the Expression Builder:
1.. Start the Expression Builder.
2.. How?
3.. You can start the Expression Builder from most places where you write
expressions, such as in a property sheet, a Criteria cell in the query
design grid, or the Macro window.
4.. In a property sheet or the lower pane of the Macro window
1..
1.. Do one of the following:
Start the Expression Builder by opening a property sheet
a.. To set properties for a form or report, double-click the form
selector or the report selector.
b.. To set properties for the data access page, click Select Page on the
Edit menu, and then click Properties on the toolbar.
c.. To set properties for a table or query, click Properties on the
toolbar.
d.. To set properties for a section on a form or report, double-click
the section selector.
e.. To set properties for a section on a data access page, double-click
the section bar.
f.. To set properties of a query field, click the cell in the Field row,
and then click Properties on the toolbar.
g.. To set properties of a query field list, click anywhere in the list,
and then click Properties on the toolbar.
h.. To set properties for a control, click the control, and then click
Properties on the toolbar.
Open a macro in macro Design view
1.. In the Database window, click Macros under Objects.
2.. Click the name of the macro you want to open.
3.. Click the Design button on the Database window toolbar.
2.. Click the property or action argument box that will contain the
expression.
3.. Click the Build button next to the property or argument box.
If a property has more than one builder associated with it, Microsoft
Access displays the Choose Builder dialog box. Click Expression Builder and
click OK.
1.. Note If the property box or argument box where you start the
Expression Builder already contains a value, that value is automatically
copied into the expression box.
2.. In the query design grid or a macro condition
3.. 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.
1.. Right-click where you want to insert the expression.
2.. On the shortcut menu, click Build.
1.. 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.
"Mike Turco" <mi*********@ya hooSPAM.com> wrote in message
news:z7******** ************@co mcast.com...
I like using the expression builder for a lot of different things but it
isn't always available when I want to use it, for example in the code
window, or in all of the control properties. I am usually stuck having to
go
into the database window, creating a new query, etc., and then
right-clicking in a field and selecting build.
Is there a shortcut key, a way to add a button to an Access toolbar, or
something like that so I can use to call up the expression builder?
Thanks,
Mike
