StrConv (1 Viewer)

[deepbreath]

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]

Try
me!name=UCase(left([Name],1) & Mid([Name],2)

 

[KevinM]

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