How to capitalise

[PayeDoc]

Hello All

I have a text field on a form where valid entries will be a combination of
alphas and numerics - e.g.

re46 gt3
tr 435
frtrg
54635

are all valid.
I would like an afterupdate event to capitalise and alphas in the string,
without changing any numerics or spaces.
I'm sure this can be done, but can't see how!

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Linq Adams via AccessMonster.com]

Simple as using UCase()

UCase("re46 gt3")

yields

RE46 GT3

 

[PayeDoc]

Hello

Many thanks for your help - worked a treat!!

Les