capital letters form

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Capital Letters on Form

Capital Letters on Form

resolvedResolved · Medium Priority · Version 2007

Katrina has attended:
Access Introduction course
Access Intermediate course

Capital Letters on Form

Hello, on my form I have a box where I write a reference, wither FA000000 or FAM00000000 (so two letters followed by six numbers, or three letters followed by seven numbers).

I want the two or three letters to automatically become capital after they're entered?

People have recommended putting coding in After Update in Event, but I don't know what to write. I tried >LL/000000;;_ in the Input Mask, but is useless when I want to use the longer reference.

Thanks for any help.

RE: Capital Letters on Form

Hi Katrina,

in your Format enter >

this will convert all text to capitals.

nice and simple ;)

Thanks
Paul

RE: Capital Letters on Form

Thank you! I wish I realised how easy that was. Worked a treat :)


 

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips


Server loaded in 0.08 secs.