Capitalizing the First character of a name using input mask

[n_m]

Hi,

Am trying to do the above & am finding that '> ' function capitalizes all the letters - is there any way of forcing caps on the first character?

Thanks in advance

 

[Norie]

Are you sure you mean input mask?

 

[n_m]

Absolutely sure - if you can do it by validation I'd accept that too

 

[Norie]

Are you 100% sure?

When I put > in the Input Mask property of a field in a table or form Access doesn't allow me to enter any data?

If I put > in the Format property of a field in a table or form then the data entered is capitalized.

 

[Tanis]

I'd would suggest you use a function for this. Such as:-

SELECT UCase(Left([FieldName,1)) & LCase(Right(FieldName,Len([FieldName])-1)) as FirstLetterOnly
FROM yourTable;

 

[Tanis]

Sorry, should have said SQL and not function. This is the function.

Public Function Capitalize(str As String)

Dim i As Integer
Dim wasspc As Boolean

wasspc = True

For i = 1 To Len(str)
If wasspc Then
str = Left$(str, i - 1) & UCase(Mid(str, i, 1)) & Right(str, Len(str) - i)
End If
wasspc = IIf(Mid(str, i, 1) = " ", True, False)
Next i

Capitalize = str

End Function

 

[Norie]

Tanis

Do you really need a loop?

Public Function Capitalize(str As String) 

     Capitalize = UCase(Left(str, 1))  & LCase(Mid(str, 2))

End Function

 

[Tanis]

Hi Norrie. No, the loop is not necessary. However, in my defence it was one of the first functions I wrote, and as it worked I saw no reason to change it. Point taken though.

 

[CT Witter]

You could also try this input mask:

>L<?????????????????? (Holds up to 18 chars)

The > forces all following text to be uppercase. The L requires a letter. The < forces all following text to be lowercase. Each ? allows any letter or no letter, and there is one fewer question mark than the maximum number of letters you want to allow in the field (19, including the leading capital letter). The Field Size setting must be greater than this maximum.

HTH,
CT

 

[Tanis]

Yeah, that's fine if you can guarantee that the field length does not exceed the number of characters of the input mask. That is why I use a function. Horses for courses. Whatever suits you best.