ACC2002: AutoCorrect Does Not Capitalize the First Word of the First Sentence (298605)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q298605
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 2000 version of this article, see 297020.

SYMPTOMS

When you type text data into a Text or Memo field or control in Microsoft Access with the AutoCorrect Capitalize first letter of sentence feature enabled, you find that the first word in the field is not capitalized.

RESOLUTION

Use the StrConv function to force capitalization of the first word. For additional information about how to use the StrConv function, click the article number below to view the article in the Microsoft Knowledge Base:

298607 ACC2002: How to Use the StrConv Function to Capitalize Words and Phrases

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. On the Tools menu, click AutoCorrect Options.
  3. Click to select the Capitalize first letter of sentence check box, and then click OK.
  4. Click Tables under Objects, click the Categories table, and then click Open.
  5. On the Insert menu, click New Record.
  6. In the Category Name field, type the following:

    test

  7. In the Description field, type the following:

    this is sentence one. this is sentence two.

    Note that the first word of the first sentence is not capitalized, but the first word of the second sentence is capitalized.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbdta kbnofix KB298605
©2003 Microsoft Corporation. All rights reserved.