R
Richard Martin
How do i use the UCase to make a field uppercase only?
Thank you.
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Al Camp
Richard Martin said:How do i use the UCase to make a field uppercase only?
Thank you.
C
Cheryl Fischer
In VBA code, as a variable:
strNameInCaps = UCase([MyField])
In a query:
NameInCaps: UCase([MyField])
hth,
strNameInCaps = UCase([MyField])
In a query:
NameInCaps: UCase([MyField])
hth,
A
Al Camp
Richard,
I think you're saying how do I force entries in a field to be Upper Case,
even if the user enters the data in Lower Case?
On the AfterUpdate event of a field called (ex.) [MyField1]... and a user
entry of "aBcDeF"
[MyField1] = UCase([MyField1])
will store the entry in Upper case even if the user entered uppercase,
lowercase, or a mix of each ("ABCDEF")
Note: Just using the ">" Format for a field will DISPLAY any entry in
upper case, but does not save the data in the table as uppercase.
I think you're saying how do I force entries in a field to be Upper Case,
even if the user enters the data in Lower Case?
On the AfterUpdate event of a field called (ex.) [MyField1]... and a user
entry of "aBcDeF"
[MyField1] = UCase([MyField1])
will store the entry in Upper case even if the user entered uppercase,
lowercase, or a mix of each ("ABCDEF")
Note: Just using the ">" Format for a field will DISPLAY any entry in
upper case, but does not save the data in the table as uppercase.
G
Guest
??
-----Original Message-----
.
B
Bruce M. Thompson
How do i use the UCase to make a field uppercase only?
In addition to the other solutions offered, you can also force the entries to
upper case as they are typed from within the control's "KeyPress" event
procedure:
'**********
Private Sub txtUpper_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub
'**********
In addition to the other solutions offered, you can also force the entries to
upper case as they are typed from within the control's "KeyPress" event
procedure:
'**********
Private Sub txtUpper_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub
'**********