Article ID: 297020
Article Last Modified on 12/12/2002
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q297020
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 2002 version of this article, see 298605.
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:
253911 ACC2000: 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
- Open the sample database Northwind.mdb.
- On the Tools menu, click AutoCorrect.
- Click to select the Capitalize first letter of sentence check box, and then click OK.
- Click Tables under Objects, click the Categories table, and then click Open.
- On the Insert menu, click New Record.
- In the Category Name field, type the following:
test
- In the Description field, type the following:
Note that the first word of the first sentence is not capitalized, but the first word of the second sentence is capitalized.
this is sentence one. this is sentence two.
Additional query words: prb capped doesn't
Keywords: kbbug kbnofix kbdta KB297020
