Microsoft Office Tutorials and References
In Depth Information
Access Procedures
Titles
Initials
MiddlePart
LastName
ing.
P.
Bogers
Prof. Dr.
A.H.
den
Dolder
Splitting the field into Title, Initials, and LastName is done by identifying the
selection, the portion in front of the selection, and the portion behind the
selection. To get the MiddlePart, the same kind of split is done on the
LastName field.
Follow these steps:
1. With Forms selected, press the New button on the database window to
create a form from which to run this code. Leave the default choice of
Design view. From the combo box at the bottom, select the table
tblName as shown in Figure 79 :
Acs
Figure 79 – Creating a New Form
2. Press OK to display the form in design view.
3. Maximize the design window by double-clicking the title bar showing
frmName : Form. Next, double-click the title bar of the tblName popup
form, which selects all fields. Now drag and drop all the fields to the
gray detail area of the form and align them as shown in the sample
form in Figure 80 .
 
Search JabSto ::




Custom Search