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

Capital Letters on Form

ResolvedVersion 2007

Thu 21 Mar 2013, 16:48 Delegate Katrina said...

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.

Fri 22 Mar 2013, 11:41 Trainer Paul said...

RE: Capital Letters on Form

Hi Katrina,

in your Format enter >

this will convert all text to capitals.

nice and simple ;)

Thanks
Paul

Fri 22 Mar 2013, 16:05 Delegate Katrina said...

RE: Capital Letters on Form

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

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Capital Letters on Form

Capital Letters on Form

RE: Capital Letters on Form

RE: Capital Letters on Form

Access articles

Access tip:

Random sampling