First letter cap in an expression

[sto]

How would you change the case on the first letter of a field in an expression.

 

[WayneRyan]

STO,

fld = Ucase(Mid(fld, 1 ,1)) & Mid(fld, 2, Len(fld)-1)

Didn't try it, but that's the general idea.

HTH,
Wayne

 

[thornmastr]

An example to get you started

?ucase(left("test",1))
T
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[KenReay]

Hi

If you are using Access 2K or XP the Proper() might help you,

if you are using Access97 or before then Proper() is not available, if you mean ONLy fisrt letter of first word, then =Upper(Left(txtBox.1)) & Mid(txtBox,2) should do it

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[KenReay]

Hi

OOPS, switched to wron language there

=UCASE(Left(txtBox.1)) & Mid(txtBox,2) should do it

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[pgk]

Hi,
Maybe you can use the StrConv function.

Syntax: StrConv(string,vbProperCase) Hope it helps. Let me know what happens.
With regards,
PGK