Re: Need string for capitalization
From: Alex Ivanov (consul_at_collegeclub.com)
Date: 02/18/04
- Next message: lbrinkman: "Another Opinion"
- Previous message: Jean: "Support for Foreign languages such as Chinese & Korean"
- Maybe in reply to: felix: "Re: Need string for capitalization"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Feb 2004 22:32:11 -0800
Mid(YourString,1,1)=Ucase(Left(YourString,1)
Alex.
"fredg" <fgutkind@att.net> wrote in message
news:1dehn99sqvs61$.1rl2pi1iouf5i.dlg@40tude.net...
> On Tue, 17 Feb 2004 19:14:29 -0500, Kathy MacAthur wrote:
>
> > Hope someone can help.
> >
> > I'm trying to capitalize the first letter of a field but the string I am
> > using capitalizes the first letter, but changes the second and third
> > characters and UN capitalizes them. (Example, Oregon. If someone
correctly
> > enters OR for state name it is changed to Or.) I need a string that
will
> > only capitalized the first letter and leave the remaining characters as
> > entered.
> >
> > The string I'm using is StrConv([fieldname],3)
> >
> > Any suggestions?
> >
> > Thanks,
> >
> > Kathy
>
> Kathy,
> That is the correct behavior of StrConv([FieldName],3)
>
> In a Form, on a Report, in a Query?
>
> Code theAfterUpdate event of the control on the form:
> [ControlName] = UCase(Left([ControlName],1)) & Mid([ControlName],2)
>
> In a report control Source:
> = UCase(Left([ControlName],1)) & Mid([ControlName],2)
>
> In a Query:
> Exp: UCase(Left([ControlName],1)) & Mid([ControlName],2)
>
> Only the first character in the field will be Upper Case.
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.
- Next message: lbrinkman: "Another Opinion"
- Previous message: Jean: "Support for Foreign languages such as Chinese & Korean"
- Maybe in reply to: felix: "Re: Need string for capitalization"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
