Capitalization...where to put the function ????

[Chris McK]

Thanks for reading...

I have a form built from a table that asks for a persons first name. The field name is 'First Name'. I scoured the internet and came accross some code, on a wonderful site, that would supposedly automatically capitalize the first letter entered into that field. Here's the code/funtion

(Q) How can I capitalize the first character of each word in a field/string

(A) Under Access 97, you can use the StrConv function. For example

StrConv("dev ashish", vbProperCase

My question is where do I place this code ? Is it at the table level, or the form level and exactly where ???

any help would be greatly appreciated

thank

 

[Chris McK]

That worked beautifully....almost

I can see it update the field when I leave it, but I then get an error that says...

Run-time error '2115':

The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Access from saving the data in the field.

Weird part is I've put the code in the AfterUpdate property and the ValidationRule property is blank....any ideas ????