Changing Case

M

Mike Green

Hi all
This is quite a stright forward one that I know it has been posted here
before, but I can't find the answer!.. I need to change the entered text in
a form to UPPERCASE. Not just display but to save it as UPPERCASE. I
beleve there is VB that can be used on the afterupdate event for that cell.
Can anyone help please?

Thanks in advance.

Mike
 
F

fredg

Hi all
This is quite a stright forward one that I know it has been posted here
before, but I can't find the answer!.. I need to change the entered text in
a form to UPPERCASE. Not just display but to save it as UPPERCASE. I
beleve there is VB that can be used on the afterupdate event for that cell.
Can anyone help please?

Thanks in advance.

Mike
Click to expand...

Run an Update query.
Update YourTable Set YourTable.[FieldName] = UCase([FieldName]);
 
K

Klatuu

You could use an input mask.
The > forces all characters entered to upper case. the C is optional entry,
any character. So, let's say the table field is defined as 10 characters,
then
CCCCCCCCCC
Click to expand...
will change all alpha characters to upper case and accept up to 10 characters.
 
Top