Question data inputting

[peterjb44]

Hi all,

is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital

please can you let me know how if it can be done

thank you

peter

 

[jdraw]

Yes, see
http://www.techonthenet.com/access/functions/string/strconv.php

 

[peterjb44]

Hi jdraw,

thanks for the reply,

problem is I forgot to mention that I'm a novice, so I have no idea how to get that working

any help would be appreciated

peter

 

[John Big Booty]

In the Field's After Update event you could use code along the lines of;

Me.YourTextField = [URL="http://www.techonthenet.com/access/functions/string/strconv.php"]StrConv[/URL](Me.YourTextField, 3)

 

[peterjb44]

Hi John big booty,

Thanks for you reply,

I tried your way but I got an error

I managed to get it working, by going to the table in design mode then create data macro then before change then set field, I then put my field name (company) in name and StrConv([Company],3) in value

thank you both for you input

peter