Access 2000 field properties

T

trainerab

Does anyone have any suggestions how I can make a text
field in a TABLE appear in Proper case? I can use > or <
to get everything upper or lowercase but I want first
letter of names to appear in capitals and the rest of
their name in lowercase i.e. John Smith

Many thanks in anticipation of your help
 
Top