Simon wrote:
On my access forms when i enter text how do i automatical get it ti
change the first letter of each word as a capital and the rest of the
work in lower case.
I want to do this as when i write in customer adress i want it to to
change it automaticaly
Hope someone can help
Simon
In your afterupdate event, assumes name of field is testfield, you could
enter
Me.testfield = strConv(testfield,vbProperCase)
However, I would set a flag on this. At the top of the code module,
under Option Explicit, enter something like
Dim blnProper As Boolean
Now in the OnCurrent event of the form, enter
Dim blnProper = False
In the afterupdate event of the field, enter
If not blnProper then
Me.testfield = strConv(testfield,vbProperCase)
blnProper = True
Endif
Thus, when you enter the record, the flag is set to false. If false,
and the field gets changed, it will propercase the field. However, the
person can overwrite the propercasing is so desired after the first
propercasing.