ACC97: ????? ??????? ???? StrConv ??????? ?????? ??????????? ??????? ?????????

?????? ????????? ?????? ?????????
???? ???????: 302499 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

?????? ??? ????? Microsoft Access 2000 ?? ??? ???????? ???? 253911.

?????? ??? ????? Microsoft Access 2002 ?? ??? ???????? ???? 298607.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ???????? ???? ????? ???? StrConv ????? ??????? ???? ????????? ????? ????? ?? ?????? ?? ?????? ?? ???????. ?? ????? ??? ?????? ???????? ??????? ???? ??? ?????? ??????? ??? ???????:
  • ????? "MacDonald" ??? "Macdonald."
  • ????? "van Buren" ??? "Buren Van."
  • ????? "VI Pratt James" ??? "vi James Pratt."

??????? ????

???? ??????? ?????? StrConv ????? ???? ?????? ?? ????? ???? ?????, ??? ???? ????? ?? ???? ????? ???? ???? ????? ?????. ???? ?????? ?? StrConv (????? ? ???????) ??? "?????" ?? ??????? ?????? ? "???????" ?? 1 ?? 2 ?? 3. "?????" ???? ????? ???? ????? 1? ??????? ?? 2 ? 3 ???? ????? ????? ?? ?? ???? ????? ??????.

??? ????? ?????? StrConv ?? Visual Basic for Applications (VBA) ? ????? ?? ??????? ??????? 1 ?? 2 ?? 3 ? ????? ????? ??????? ??? ??????? ???????:
vbUpperCase ????? ??????? ??????? ??? ???? ?????.
vbLowerCase ????? ??????? ??????? ??? ???? ?????.
vbProperCase ????? ????? ????? ?? ?? ???? ?????? ??????? ??????? ???????? ??? ?????.
??????: ???? StrConv ????? ???? ?? ????? ???????? ??? ? ??? ???? ???? ??? ??????? ??? ??? ????? ????? ????????? ?? ????? ???? ??????.

demonstrating ???? StrConv

  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
    					

??????? StrConv ?? ????????? ???????? ?? ????? "???_???????" ???? ????? ??????

  1. ????? ????? ???? ????? ??? ???? MyNamesList.
  2. ????? ????? ???? ???? ???? ????? ????? ????? LastName ???? ????? ?????? ?? ????? ??????.
  3. ?? ???? ??? ???? ???? ??????? ?? ??????? ???? ???? ??? ?????.
  4. ????? ????? "???_???????" ???? ???? ??? ??????? ??? ????? ????? ??????:
    Private Sub LastName_AfterUpdate()
    LastName = StrConv(LastName, vbProperCase)
    End Sub
    					
  5. ?? ??????? ???? ???? ??? ?????.
  6. ???? ??????? ???? ??? ??????? ?? ?????? 1 ?? ????? ????? "?????" ????? ??? ????? ????? ???????. ???? ??? ??? ?????? ??? ??? ??????? ??? LastName ?? ???? ???? ???? ??????.

???????? StrConv() ?? ???????

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

    ???? ?? ???? ?????? ???? LastName "??? ???????" ? "????? ????? ??? ????? ?? ??????? ???? ???? ?? ????? ???? ???? ????? ????? ??????.

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

  • ????? ????? ???? ???? ??????? ?????????? ???????:
    ???????: SetValue
    ??????: Screen.ActiveControl
    ?????: StrConv(Screen.ActiveControl,3)
    ??????: ???? ??????? ??? ??????? ?? ????? "???_???????" ?? ???? ???? ?? ?????. ??? ????? ??? ??????? ?????.

?????

????? ?? ????????? ??? ????? ?????? ?????? StrConv ????? ???? ????????? ?? StrConv ?? ???? ??? ??????? StrConv ??????.

???????

???? ???????: 302499 - ????? ??? ??????: 12/????/1428 - ??????: 3.1
????? ???
  • Microsoft Access 97 Standard Edition
????? ??????: 
kbmt kbhowto kbprogramming KB302499 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????302499
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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