Microsoft KB Archive/61505

Works: Searching for a Date in a Database

PSS ID Number: Q61505 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother

= SUMMARY =

To search for a date in a Database file, the field width (set with Format Field Width) for the date must be equal to or greater than the date in BOTH Form view and List view. If the field width is not wide enough in one or both of the views, the error message “No Match Found” will appear when attempting to do the search.

For example, the width for the date field that contains “1/1/90” must be set equal to or greater than 6 (the number of characters) in both Form view and List view.

Note: The width of the date field in Form view need not be identical to the width of the date field in List view. For instance, you can set the width for the date 1/1/90 equal to 6 in Form view, and then set the width equal to 7 in List view.

KBCategory: kbother KBSubcategory: dworkskb Additional reference words: ====================================================================== Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.