Changing case in text fields

[Doctorswamp]

Hi

Is there a way of changing the case of text that has been entered in a table?

Want a form to display capitalised names, say, no matter how they were entered. Know that they can be displayed in all caps using >.

Thanks

 

[Matt Greatorex]

I'm sure there are others, but one way would be to put this into the AfterUpdate event of the field

[Forms]![[I]form name[/I]]![[I]field name[/I]] = Ucase([Forms]![[I]form name[/I]]![[I]field name[/I]])

 

[RV]

Here's another one, to be put in the After Update event of your field:

Me.fieldname= StrConv(Me.fieldname, vbUpperCase)

RV

 

[The_Doc_Man]

Not clear on whether you wanted all uppercase or what Word calls "proper" case or "title" case.

Give us an example of the string you might have in the table BEFORE conversion and how you want to see it AFTER conversion.

 

[Doctorswamp]

Hi guys

What I'm after is to convert 'john smith' or 'JoHn SmItH' into 'John Smith'.

And if there are other options for the final format they might be useful too.

 

[Matt Greatorex]

[Forms]![form name]![field name].Value = StrConv([Forms]![form name]![field name].Value, vbProperCase)

 

[Doctorswamp]

Mark

That's just great, thanks. Sorry to be slow to respond, few days hols.