- Example) Formatting Phone Number w/ Area Code (xxx) xxx-xxxx
- Switch to Design View
- Select the field you want to format
- At the bottom select the General Tab
- Select Input Mask Box and click on the ... button at the right.
- Select Phone Number option
- Click on Next
- Leave !(999) 000-0000 the way it is. This is a default.
- Click Next
- Select which option you want it to look like
- Click Next
- Click Finish
- Example)Choosing a city that is either Auburn, Bay City, Flint, Midland, or Saginaw
- Switch to Design View
- Select the field you want to alter (City)
- At the bottom select the Lookup Tab
- In the Display Control box, select Combo Box
- Under Row Source Type, select Value List
- Under Row Source, enter the values how you want them displayed, separated by a comma. (Auburn, Bay City, Flint, Midland, Saginaw)
- NOTE:This will not alphabetize them for you, so you will have to do that yourself. It should look something like this:
- NOTE:This will not alphabetize them for you, so you will have to do that yourself. It should look something like this:
- Select in the datasheet view and you should see the change when you go to the city field.
Back to top
Relationships
Back to top
Forms
Back to top
Create a Form using the Wizard
Back to top
Reports
Back to top
Create a Report using the Wizard
Back to top
Creating Mail Merge Labels using a Wizard
0 Response to "next"
Posting Komentar