MJR wrote:
Could anyone please help me change data in uppercase to data in
propercase in MS Access?
Updtae query.
UPDATE TableName
SET TableName.FieldName = strConv(TableName.FieldName, 3)
(please test on a copy of your table first)
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com