L
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
the text is lower case? EG: Henry Beeler
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer Cohen
Try
StrConv([FieldName], vbProperCase)
StrConv([FieldName], vbProperCase)
L
lschuh
What if I just wanted to manipulate the output in a query or tbl? Is this
the only way to format this?
the only way to format this?
Ofer Cohen said:Try
StrConv([FieldName], vbProperCase)
--
Good Luck
BS"D
lschuh said: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
O
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
SELECT StrConv([FieldName],3) AS UpperFieldName
FROM TableName
I'm not familliar with a different way on doing that
--
Good Luck
BS"D
lschuh said:What if I just wanted to manipulate the output in a query or tbl? Is this
the only way to format this?
Ofer Cohen said:Try
StrConv([FieldName], vbProperCase)
--
Good Luck
BS"D
lschuh said: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