?????? ?? ??????? Access 2002 ??? ?????? ????? ???? ?? ??? StrConv ?????? ?? ????? ???? ????

???? ?????? ???? ??????
???? ID: 298607 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Moderate: ??? ??????, ??????, ?? ?????????????? ??????? ?????? ???

?? ???? Microsoft Access ??????? (.mdb) ?? ??? ???? ???? ???? ???

???? Microsoft Access 97 ?? ??????? ?? ??? ?? ????, ?????302499.
???? Microsoft Access 2000 ??????? ?? ??? ?? ???? ??, ?????253911.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

?? ???? ?????? ???? ?? ?????????? ?????? ?? ????? ???? ?? ??? ?????? ????? ??StrConv?? ?? ???? ???? ?? ????? ???? ?? ???? ?? ?? ??? ?????? ????? ?? ????? ?? ???? ??? This function is not affected by leading spaces, but it does have the following limitations for some names:
  • Changes "MacDonald" to "Macdonald."
  • Changes "van Buren" to "Van Buren."
  • Changes "James Pratt VI" to "James Pratt Vi."

???? ???????

TheStrConvfunction can be used to change the case of a string to uppercase, lowercase, or so that the first letter is uppercase. The syntax isStrConv(string,conversion, where "string" is the text string and "conversion" is 1, 2, or 3. For "conversion," uppercase is 1, lowercase is 2, and 3 makes the first letter of each word uppercase.

When writing theStrConvfunction in Visual Basic for Applications, instead of the integers 1, 2, or 3, you can also use one of the following constants:
vbUpperCaseConverts the entire string to uppercase.
vbLowerCaseConverts the entire string to lowercase.
vbProperCaseConverts the first letter of each word to uppercase and the remaining letters to lowercase.
???::TheStrConv?????? ?? ??? ??? ???? ???????? ??? ?? ?? ???? ????? ??; ???????, ?? ???? ??? ??????? ?? ??? ????? ??? ???? ??? ?? ??? ????? ?? ???? focuses ???

StrConv ?????? demonstrating

  1. Microsoft Access ??? ??????? ????, ?? ???? ??? ?? ??? ????? ??????? ??????
  2. ???? ?? ???? ??? ????? ????? ??? ?????:
       Field Name: FirstName
       Data Type: Text
    
       Field Name: LastName
       Data Type: Text
    						
    ?????? ?? ??? ??? ??????MyNamesList.
  3. ?????? ??? ????? ????? ??? ??????:
       john chen
       joanna fuller
       becki culbert
       jeff smith
    					

??? ??? ??? ???????? ?? AfterUpdate ??? ??? StrConv ?? ????? ????

  1. MyNamesList ???? ?? ?????? ?? ??? ??????? ??????
  2. ??? ????? ???????? ?? ??? ??????FirstName, ??LastName????? ??? ?? ???? ?? ?????????? ????????? ????
  3. ??? ??? ????? ?? ????? ???? ???? ??, ?? ????? ???????????? ????????????? ??..
  4. ?? AfterUpdate ??? ??? ????LastName??? ????? ??? ????? ????? ????????? ??:
    Private Sub LastName_AfterUpdate()
    LastName = StrConv(LastName, vbProperCase)
    End Sub
    					
  5. ????? ???????????? ??,??? ????, ?? Microsoft Access ?? ?????.
  6. ??? 1 ??? ??? ???? ?? ??????? ?????????????????, ?? ??????? ??? ??? ??? ??? ???? ????? ??? ?? ????????? ?? ?? ?? ?? ??????? ???? ?? ??? ????, ??? ??? ?? ??? ??? ?? ???? ???

??? ?????? ??? StrConv ?? ????? ????

  1. MyNamesList ???? ?? ?????? ??? ?? ?????? ?????, ?? ??? ?????? ?????? ????? ?? ????? ????? ???? ??? ????? ?????? ???? ????:
    FullName: = StrConv ([LastName] "," & & [FirstName], 3)
  2. ?????? ??????

    ????? ??? ?? ????? ??? concatenated ???, ?? ???? ?? ??? ??????? ?? ??? ???? ???? ??? ?????? ??? ?? ????? ????? ?? ?????? ???

???? ?????? ??? StrConv ?? ????? ????

  • ????? ??????????? ?? ??? Proper ???? ?? ?????? ?????:
    ??????: SetValue
    ????: screen.ActiveControl
    ??????????: StrConv(screen.ActiveControl,3)
    ???:: ?? ?????? ?? ??? ?? ???? ??? ??AfterUpdate???? ??????? ?? ??? ???????? ?? ???? ?? ?? ?? ?????? ?? ???? ???? ?? ??? ??? ???

??????

StrConv ??????, Visual Basic ?????? ???, ?? ???? ????? ?? ???? ??? ???? ??????? ?? ??? ????? ????Microsoft Visual Basic ??????????? ???????????, ??????strconvOffice ????? ?? ????? ????????, ?? ???? ?????????? ?? ??????

???

???? ID: 298607 - ????? ???????: 17 ??????? 2011 - ??????: 4.0
???? ???? ???? ??:
  • Microsoft Access 2002 Standard Edition
??????: 
kbfunctions kbdta kbhowto kbmt KB298607 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:298607

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com