Using the Expression Builder

Where can I use the Expression Builder?

The Expression Builder makes it easy to enter expressions in Access. It allows you to select bar code functions in the new module and to select fields in your reports.

The Expression Builder can be used in many places where you need to enter expressions.

- In a report or form design view, you can use the Expression Builder to enter an expression in the Control Source property of a Text Box object.

- In a query design view, you can use the Expression Builder to enter an expression in a query field.

How do I open the Expression Builder in a report or form design?

In a report or form design view;

- Select a Text Box;

- Choose menu View | Properties, click the Data tab and place the cursor in the Control Source field.

Click to open use Expression Builder.

How do I open the Expression Builder in a query design?

The Build icon is on the Query Design toolbar (choose menu View | Toolbars | Query Design).

In a query design view you can also right-click in a query field a click Build...

Using the Expression Builder

To see the list of functions in module CiaxCom.

-  Double-click Functions and select your database in the expanded list, then select module CiaxCom.

- Double-click a function to add it to the expression you are building. For example, to print a Code 128 bar code you must select function CIA_CODE128.

CIA_CODE128(<<Msg>>)

Replace <<Msg>> with the name of the field or the expression you want to print as a bar code.

CIA_CODE128( [MyField] )

To select the field, from list of fields in the current report design;

- Double-click Reports then Loaded Reports and select your report, then click <Field List> to see a list of fields.

- Double-click a field to add it to the expression at the current cursor position;

CIA_CODE128( [MyField] )

- Click OK.

Note: You must press ENTER to accept the expression before closing the properties window.