all caps after update

[antonyx]

if this makes the first letter a capital.. how can you make every letter a capital..

Me.field = UCase(Left(Me.field, 1)) & LCase(Mid(Me.field, 2))

 

[Rickster57]

case

Did you try me.field=ucase(me.field)?

 

[antonyx]

thanks, that does seem like the logical answer in hindsight