473,508 Members | 2,460 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to force text in a field to upper case although caps lock is off?

76 New Member
Hey everybody!*
I have forms in my database.* Some fields I want to force so that whatever text i fill in must be uppercase, even though caps lock is off.
*
I have tried after update events, before update events, but nothing works!
*
What I have now on that specific fields is in the prpert sheet i put a ">" then it will show the text as uppercase although typed with caps lock off. - But~
It still save it as lowercase in the underlying table.
I want the underlying table alse to be in upper case as on the form where the text is entered.
*
Could someone please help me!
*
thanks
Ryno
Jan 27 '11 #1
1 5367
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
Use the build in function UCase in the afterupdate event of the textbox istelf.
Expand|Select|Wrap|Line Numbers
  1. Private Sub tb_Test_AfterUpdate()
  2.     Me.tb_Test= UCase(Me.tb_Test)
  3. End Sub
Jan 27 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
13602
by: tanas | last post by:
Is there a way to convert lower case text to upper case text in PHP? Any help would be appreciated. Thanks
18
4895
by: Robert | last post by:
Hi! I was wondering if the was any way to determine the state of the caps lock key, on or off. Of course I can capture the key events and see whether the caps lock is pressed, but that does not...
4
6615
by: Peter D | last post by:
I have a second hand bar code reader (keyboard wedge) en i can read the bar codes but after every scan he turns my caps lock on. (GRRRRRR). I search a code to turn my caps lock off or can anyone...
4
13042
by: programmerforhire | last post by:
Hello all, Is there a way to setup an ms-access table so that when I enter text in the 'datasheet' mode, it will automatically be converted tp upper case. Or must I use a Form for this? rex
3
13914
by: Addio | last post by:
Hello, MSA Group, Does anyone know how to convert all UPPER CASE text to Initial Caps? I'm familiar with ucase and lcase, but don't know of any function to handle Initial Caps, i.e. every word...
5
10267
by: Nelson | last post by:
In my web form, I am converting all lower case letters to upper case when the user types the characters in the edit boxes. I am achieving that by injecting client side script (onkeyup event) for...
5
21297
by: bob | last post by:
Now this ought to be a simple matter. But nothing's simple in the Net world, I'm finding. In vb6 you could use "!" to force text to upper case in the format function. I've searched the vb.net...
7
19409
wassup
by: wassup | last post by:
Hi all, I need a help again. How to set the textbox auto change to Upper Case without on the Caps Lock Key.
5
3963
by: Matuag | last post by:
How can I enable Caps Lock after the form or database opens?
5
4490
by: =?Utf-8?B?cmtibmFpcg==?= | last post by:
How can I force the users to enter characters in uppercase? I want to do this in a TextBox control of an aspx page. Then I want the same to be moved to inside a GridView control. Thanks.
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7321
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
5623
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5045
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4702
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3191
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1544
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
762
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.