View Full Version : StrConv


deepbreath
05-24-2001, 07:49 AM
i am trying to convert first letter of "NAME" to capital by using
[NAME] = StrConv([NAME], 3)
But when i run the form, it gives error that "the property is read only, it cannot be set". can you help me
thankx

charityg
05-24-2001, 08:12 AM
Try
me!name=UCase(left([Name],1) & Mid([Name],2)

KevinM
05-24-2001, 08:32 AM
The problem is your field called 'Name'. This is a reserved word in Access and I Recommend that you change it to something else.

This WILL cause you problems.

HTh