Data entry form, capitalise first letter onlyin properties how?

[Guest]

Can someone please tell me how I ensure that after data has been netered into
a form that only the fiirst letter is capitalised regardless of how the data
is entered by using the format field in properties. I can make all the
letters capitalised by entering > as the format but can't find how to
capitalise just the first letter - Help!

 

[Jeff Boyce]

Gaile

What is stored and what is displayed are not necessarily the same. Applying
a format doesn't change what is stored.

If you want to ensure that only the leftmost character is capitalized, you
can use the AfterUpdate event to basically re-write the value to the field,
using the UCase() function on the Left([yourfield],1) &
Mid([yourfield],1) -- replacing the leftmost character with its UpperCase()
equivalent.