Data entry form, capitalise first letter onlyin properties how?

G

gaile

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!
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top