Table--field--format question

[vickimurray]

I am creating a new Text field in a table. In the Field Properties I know that "> @" in the format will force all alpha characters to be saved in upper case. How can I force the format to be Proper (as a name with first letter capital and following letters lowercase)??

[JoeM]

I am pretty sure that will require VBA.
See: http://www.utteraccess.com/forum/For...-t1578532.html

[CJ_London]

You actually just need the ">" but you can't force proper case in the format property - you need to use the StrConv function in code

http://www.techonthenet.com/access/f...ng/strconv.php

With regards tables, users should not be looking at them directly anyway, So little point in using the format property there - better to use a bit of code to use StrConv to convert it after user input and before saving the record since it can be disconcerting to a user going to edit 'Abc' and it suddenly changing to 'ABC' when they click on the control

[Homegrownandy]

you don't need to put the @ to get them upper case. Take a look here:

http://www.quepublishing.com/article...43872&seqNum=7

it may be something like:

Format("VBA", "><<<<<<<<")

I haven't tested it but looking at that I don't see why It wouldn't work.

[Micron]

Consider an input mask. MS has good info with examples. From what I read on the subject recently, they can be used to force Proper Case. As a user, I find them too finicky for input, so I don't develop with them. I'd rather use expressions in a control to display as needed if it's any more involved than storing a value that's been converted with something like Ucase.