Formatting upper or lower case text

[lschuh]

Is there a way to make the first letter of text Upper case while the rest of
the text is lower case? EG: Henry Beeler

 

[Ofer Cohen]

Try

StrConv([FieldName], vbProperCase)

 

[lschuh]

What if I just wanted to manipulate the output in a query or tbl? Is this
the only way to format this?

Try

StrConv([FieldName], vbProperCase)

--
Good Luck
BS"D

Is there a way to make the first letter of text Upper case while the rest of
the text is lower case? EG: Henry Beeler

 

[Ofer Cohen]

In a query you should use

SELECT StrConv([FieldName],3) AS UpperFieldName
FROM TableName

I'm not familliar with a different way on doing that

--
Good Luck
BS"D

What if I just wanted to manipulate the output in a query or tbl? Is this
the only way to format this?

Try

StrConv([FieldName], vbProperCase)

--
Good Luck
BS"D

Is there a way to make the first letter of text Upper case while the rest of
the text is lower case? EG: Henry Beeler