How can i format field properties so that the first letter in text is always
upper case
Do you wish to STORE the text that way or just format it so that it
displays that way?
To store the data in the table, use a form for the data entry.
Code the Form control's AfterUpdate event either...
1)
[ControlName] = StrConv([ControlName],3)
The First Letter Of Each Word In The Field Will Be Capitalized.
0r ...
2)
[ControlName] = UCase(Left([ControllName],1) &
LCase(Mid([ControlName],2)
Only the first word will be capitalized.
Each has its problems.
StrConv will not properly capitalize words which should have more than
one capital letter, i.e. McGregor, O'Bannion, IBM, etc., and
capitalizes words which should not be capitalized, van den Steen, etc.
A good solution is to have a table of exceptions, and use that to
message the user as to whether the text should be changed or not.
The second example will also remove all necessary capital letters
within the body of text, i.e. van den Steen becomes Van den steen.
Both methods will only effect new entries. You will need to run an
update query to change already stored data.
