Microsoft Y2K  
Microsoft
 This static CD-based web site is representative of the computingcentral.msn.com site as of October 13, 1999.

 
Y2K home   Y2K site map
  Introduction
  ò  What is the Year 2000 Challenge?
  ò  Should I Care?
  ò  What Can I Do?
  Exploring Your PC
  ò  Three Parts of Your PC
  ò  Hardware
  ò  Software
  ò  Personal Files
  Taking Action
  ò  Action Steps
  ò  Hardware
  ò  Software
  ò  Personal Files
  ò  Action Summary
  Learning More
  ò  Quick Tips
 page pointer  FAQ
  ò  Glossary
  ò  Microsoft Product Analyzer
  ò  Microsoft Product Information
  ò  Microsoft Links
  ò  General Year 2000 Reading Links
Year 2000 Readiness Disclosure. A special feature brought to you by Microsoft Frequently Asked Questions

30. What is the best way to enter dates using Access?

The most reliable way to enter dates in Access is by using a 4-Digit Year Date Input Mask. An Input Mask that is created to allow entry of only four-digit years is the easiest way to make sure that dates are specified with accuracy for the century.

To create an Input Mask that forces the entry of four-digit years, do the following:
  1. Open the table in Design view and select the date field.
  2. On the General tab of Field Properties (at the bottom of the window), click in the Format field and select a format option that includes "yyyy" to represent the year from the drop-down list that appears.
  3. Click in the Input Mask field and then on the Builder (à) button to activate the Input Mask wizard.
  4. Click on the Edit List button of the Input Mask wizard.
  5. Click on the New Record button (>*) and fill in the fields for the new record as shown below:
    Description: 4-Digit Year Date
    Input Mask: 09/09/0000
    Placeholder: [leave blank]
    Sample Data: 12/31/1999
    Mask Type: Date-Time
  6. Close the dialog box.
  7. Select the new Input Mask from the list.
  8. Click Next, Next, and Finish to complete the creation of the new 4-Digit Year Date Input Mask.

backFAQ main page previous question29 | 31next question

Additional Terms of Use


 

 
    ⌐1999 Microsoft Corporation. All rights reserved. Terms of Use  Advertise  TRUSTe Approved Privacy Statement