Changing Case

[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

 

[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

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

 

[Guest]

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

will change all alpha characters to upper case and accept up to 10 characters.