Hello,
I would like to have all data entered into every form in my database in all capital letters as a default. Is there a way to go about this?
martin DH
Feb 27 '07
17  11550  NeoPa 32,579
Recognized Expert Moderator MVP
I also have my DBs set up to accept caps only. Here's the easy way to do it!
I'm not sure I'd describe that as the easy way Linq.
It's certainly another way, though the side-effect of forcing CAPS-LOCK on for other applications while your database is open would deter me somewhat.
We have an application at work (Not Access related at all) which has a similar effect and, as I frequently switch between running tasks, I find it a nuisance.
I think it beats all the other methods mentioned here if 1) you want all caps for all entries in a given database (as the poster here specified) and 2) you have many forms/controls involved. I think we have to remember that while many of us here are power users, the vast majority of people who use computers aren't, but rather are users who work on one application at a time.I think the same thing applies when it comes to shortcuts and "standard" methods of doing things in Access. Our knowledgebase of Access is not the as that of a customer service rep or a healtcare worker that's using an Access database.
NeoPa 32,579
Recognized Expert Moderator MVP
I suppose we'll just have to hold different opinions on that one then ;)
I'm not good at predicting what other people find complicated though. The good thing about these forums is that the OP can choose from any of the options here. I know which one I'd choose, but then I'm heavily biased :D
No, you biased? LOL! ;0)>
Thanks for your suggestion, Linq. Although, as neopa thought, this database is being used in the midst of several applications and the suggestions posted before seem to be doing the job well. Thanks though!
Martin DH
Hello,
I would like to have all data entered into every form in my database in all capital letters as a default. Is there a way to go about this?
martin DH
In design view of each form, go to properties of the text boxes and format them with ">"
Hello,
I would like to have all data entered into every form in my database in all capital letters as a default. Is there a way to go about this?
martin DH
To add to the veritable sweetshop of code that is this thread, heres another little snippet that you can place in the onkeypress event of a particular textbox you might wish to force to uppercase. -
-
Dim Character
-
Character = Chr(KeyAscii)
-
KeyAscii = Asc(UCase(Character))
-
Jim :)
Use UCASE if you use SQL statements or place a UCASE convert function on the after update event.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
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 help.
I have seen some example that looks at the characters entered in an
input field to determine if the caps lock is on, but I was wondering if
something is possible that is a bit more immediate to report the caps
|
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 tell me why
(the hell)it happens that way.
|
by: Mike L |
last post by:
How do I turn Caps Lock on, when my form opens?
|
by: GSX |
last post by:
Would somebody be able to point me in the direction of figuring out how
to determine if Caps Lock is on, Num Lock is on, INS or OVR, etc.?
I'm looking to display their status in a statusbar, but I cannot seem to
find any info on how to retrieve their state.
Thank you very much in advance.
|
by: fNew VBer |
last post by:
Hi. I'm new to Visual Basic .NET, so you'll have to bear with me . . . I
want to create an app that turns off CAPS LOCK when the SHIFT key is pressed.
I got the code to turn off CAPS LOCK to work, but it only works when the
program has the focus. How can I write an app that will do this while
running in the background?
| | |
by: yxq |
last post by:
Hello,
I have a main form, there other some controls(i.e. textbox) in the form.
I want to detect whether Caps Lock key is pressed in form-key event.
Private Sub Form1_KeyUp(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyEventArgs) Handles MyBase.KeyUp
If e.KeyCode = 20 Then
MessageBox.Show("Caps Lock is pressed!")
End If
End Sub
|
by: charlies224 |
last post by:
Hi,
I am writting a software that requires me to make sure the Num Lock is
always on and Caps Lock is always off.
First, I know how to detect if Num Lock or Caps Lock is on or off (if
someone is interested, let me know and I will send you the codes). Once
we know if the stat of Num Lock/ Caps Lock is not what we desired, we
just send the Num Lock / Caps Lock key to change the stat. From most of
|
by: Brian Parker |
last post by:
I play a DirectX game and while that game is running, I would like to
change the behavior of the Caps Lock key. When it's pressed, I don't
want it to toggle my Caps Lock on and off, but instead send a different
code instead - preferably mimicing the 4th or 5th button of a mouse
being pressed.
1) Is this doable? If so...
2) What the general idea of how to approach this?
TIA,
|
by: zacks |
last post by:
I'm not sure when it came into being, since this it the first time I
have worked very much with a password control in .NET, but if a
textbox that has a non-empty value for PasswordChar or the
UseSystemPasswordChar property is true, and the textbox has focus, if
the Caps Lock key is pressed, a warning balloon tooltip is
automatically displayed by the system. I cannot even find
documentation that describes this behaviour.
My question is,...
|
by: cmrhema |
last post by:
Hi,
Two questions
1. In windows application if we put on the below code, it will identify whether caps lock is on or not
if (TextBox.IsKeyLocked(Keys.CapsLock))
{
MessageBox.Show("caps lock on");
}
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
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 we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
