Microsoft Office Tutorials and References
In Depth Information
to False so the data is not editable. You can even have two different types of controls linked to the
same field, for example a TextBox on the Compose view and a Label on the Read view.
To create a shared field, you can simply drag the field from the Field Chooser to the Read view and
then switch to the Compose page and drag it there. This works only if you want the same type of
control in both locations. You can edit each control’s properties independently as needed.
If you want different types of controls on the Read and Compose pages:
Display the Compose page.
Using the Toolbox, add the desired kind of control to the page.
Use the Value tab in the control’s property sheet to associate the control with the field.
Display the Read page and repeat steps 2 and 3.
Creating Combination Fields
A combination field is one that combines data from two or more fields and treats it as a unit. For
example, if your form has FirstName, MiddleName, and LastName fields you can create a
combination field for full name.
To create a combination field, display the Field Chooser and click the New button to open the New
Field dialog box. Enter a name for the custom field and select Combination in the Type list. You
can see that the dialog box now displays a Formula field and an Edit button (see Figure 27.7).
Defining a combination field.
To define the field, click the Edit button to open the Combination Formula Field dialog box,
shown in Figure 27.8. For most combinations fields, you want to select the Joining Fields... option
at the top, which works by combining two or more fields into a single data item. The second
option, Showing Only..., is used when you want the custom combination field to display data from
the first non-empty field in a list you specify.