Automatic first letter uppercase

[setabery]

When entering a value to a field, is there a way to make only the first
letter upper case without using the Shift Key? For example, entering a
name.

[ManningFan]

Well, you can pull the string out, do a UCase(left(1, string)) &
right(len(strin g)-1, string) on the AfterUpdate event.

A little clumsy, but it's the best I can do on 2 hours sleep...

On Jan 24, 2:12 pm, setab...@hotmai l.com wrote:

When entering a value to a field, is there a way to make only the first
letter upper case without using the Shift Key? For example, entering a
name.

[chris.nebinger]

You could Also use the StrConv(Value, vbProperCase) to get the first
letter of each word capitilized)

Or use a function ( as ManningFan's would probably throw and error is
the string was an empty string or just one letter)

Function CapitilizeFirst Letter(Value as String) as String
Select Case Len(Value)
Case 0
CapitilizeFirst Letter=""
Case 1
CapitilizeFirst Letter= UCase(Value)
Case Else
CapitilizeFirst Letter=Ucase(Le ft(Value,1)) & mid(Value,2)
End Select
end function
On Jan 24, 1:10 pm, "ManningFan " <manning...@gma il.comwrote:

Well, you can pull the string out, do a UCase(left(1, string)) &
right(len(strin g)-1, string) on the AfterUpdate event.

A little clumsy, but it's the best I can do on 2 hours sleep...

On Jan 24, 2:12 pm, setab...@hotmai l.com wrote:

When entering a value to a field, is there a way to make only the first
letter upper case without using the Shift Key? For example, entering a
name.- Hide quoted text -- Show quoted text -