AUTO CAPS

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hello Everyone,

I have created a database at work that has fileds that I
want to have the text inputed in CAPS. For now when I
get to those fields, I have to to hit the caps lock.

Is there a way I can program the fields to automatically
go in to CAPS mode without having to hit the capslock
everyime?

Please help!

Thanks,
Steve.
 
for data entry into a form, add the following code to the AfterUpdate event
of any control where you want to change the data entry to all caps:

Screen.ActiveControl = UCase(Screen.ActiveControl)

hth
 
-----Original Message-----
for data entry into a form, add the following code to the AfterUpdate event
of any control where you want to change the data entry to all caps:

Screen.ActiveControl = UCase(Screen.ActiveControl)

hth





.
Thanks Tina for the info. Where do I add this command.
Click to expand...
Do I add it through Form Design? I do not have a form
with auto update. I just have a plain basic form that I
type my information in. When I need to update someting,
I manually do it.

Email me when you can.

Thanks,
Steve
 
Good evening

IN the format property of the textbox, simply place a > sign. This will force
the entry to upper case.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Do I add it through Form Design? I do not have a form
with auto update. I just have a plain basic form that I
type my information in. When I need to update someting,
I manually do it.

Email me when you can.

Thanks,
Steve
Click to expand...

Steve,
You are right, you do not have an Auto Update.
No one does.
You have mis-read Tina's response.
Look again.

It is the AfterUpdate event you must use NOT Auto Update.

Open the form in design view.
Select the control. Right-click and select Properties.
Click on the Events tab.
On the AfterUpdate event line, type:
[Event Procedure]
Click on the button with the 3 dots that will appear on that line.
When the Code window opens the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines write:

Me![ControlName] = UCase(Me![ControlName])

Change ControlName to the actual name of the control.
Exit the code window.
Do this for each control you wish to force text to upper case in.

Text will be stored as all caps.
Good luck.
 
Good evening

IN the format property of the textbox, simply place a > sign. This will force
the entry to upper case.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
Click to expand...

Maurice,
The > in the format property will only affect how the text is
displayed in that control. However, it is still stored in the actual
manner entered. Used in a report, it will not be all caps (unless he
again sets the format property to >).

A better solution (as I believe the OP wishes to store the text as all
caps), is to use the control's AfterUpdate event to force it.
 
fred gave you just what you need, Steve.
busy day today, i hate to leave people hanging - thanks for catching my
back, fred! :)


fredg said:
Do I add it through Form Design? I do not have a form
with auto update. I just have a plain basic form that I
type my information in. When I need to update someting,
I manually do it.

Email me when you can.

Thanks,
Steve
Click to expand...

Steve,
You are right, you do not have an Auto Update.
No one does.
You have mis-read Tina's response.
Look again.

It is the AfterUpdate event you must use NOT Auto Update.

Open the form in design view.
Select the control. Right-click and select Properties.
Click on the Events tab.
On the AfterUpdate event line, type:
[Event Procedure]
Click on the button with the 3 dots that will appear on that line.
When the Code window opens the cursor will be flashing between 2
already existing lines of code.
Between those 2 lines write:

Me![ControlName] = UCase(Me![ControlName])

Change ControlName to the actual name of the control.
Exit the code window.
Do this for each control you wish to force text to upper case in.

Text will be stored as all caps.
Good luck.
Click to expand...
 
Thank you very much Maurice for your help. it worked just
as you said. However, it took me a while to find the
area you were talking aout, but I found it.

Thanks again...
 
I have created a database at work that has fileds that I
want to have the text inputed in CAPS. For now when I
get to those fields, I have to to hit the caps lock.

Is there a way I can program the fields to automatically
go in to CAPS mode without having to hit the capslock
everyime?

Steve.
Click to expand...

Steve, I see you have a solution that you're happy with but I would
like to suggest a rethink of the idea of going to all caps.

First point:
Caps in databases in days gone by used to be there because DOS based
data could not be sorted unless it was either all caps or all lower
case. Cap A has a different ASCII number to lowercase a. Access is
case-insensitive so that requirement no longer applies

Second Point:
Caps use up much more of your screen space. Your controls have to be
longer to fit the data in and your screen becomes very crowded very
quickly ... for example, look at the difference in lengths here
1234 PACIFIC PARADISE BOULEVARD
1234 Pacific Paradise Boulevard

Third Point:
Caps are incredibly hard to read and comprehend! That's why Microsoft
use them in their EULA's (End User License Agreements) - nobody can
read them. It is also why people in these and every other Newsgroup
on the internet get snappy WITH PEOPLE WHO ALWAYS TYPE THEIR MESSAGES
IN CAPS. IT'S CALLED SHOUTING!!!! AND IT IS REGARDED AS EXTREMELY
POOR NETIQUETTE.

Fourth Point:
As a consequence, all caps applications now look very "old fashioned"
and that's probably not a reputation you want to have as a developer.

Final Point:
You owe it to your users to provide the best and easiest tools you
can. They'll not like your CAPS but they'll love you for clean, easy
to read screens.

Cheers,
Brett
 
Back
Top