Best way to effect Case

[Gavx]

On a form I have various fields that I would like to either use UCASE or ProperCase.

I thought I would effect this using the After Update method.

Using the expression builder to write the code what should the expression look like - I am having trouble with the syntax.

Thanks for your help.

 

[vbaInet]

For UPPER case you can out ">" in the Format property of the textbox. Or if you want to save it as upper case (which you really shouldn't do) then:

Me!MyField = Ucase(Me!MyField)

For ProperCase look into the StrConv() function.

 

[vbaInet]

What is the issue with saving in upper case? Is it the readability?

It can be formatted to uppercase.

 

[gemma-the-husky]

What is the issue with saving in upper case? Is it the readability?

you can have whatever you want, but access is by default case insensitive, so somefield = "SOMEVALUE" and somefield = "somevalue" work irrespective of case.

Uppercase may be sensible for some fields, to maintain consistency (eg in tables with text keys) but uppercase is often not the best choice, for general appearance.

 

[vbaInet]

It's a similar principle to, if it can be calculated (or formatted in this case) it doesn't need to be saved. But of course it's up to your needs.