|
 |
access thread: Uppercasing (is that a word?)
Message #1 by "Bob Bedell" <bdbedell@m...> on Thu, 10 May 2001 04:04:16
|
|
Hi,
Does anyone know a way to force all the lowercase data in an Access tables
records to uppercase.
Thanks in advance.....
Message #2 by "Craig Flannigan" <ckf@k...> on Thu, 10 May 2001 10:04:20 +0100
|
|
Use the UCase() command.
----- Original Message -----
From: "Bob Bedell" <bdbedell@m...>
To: "Access" <access@p...>
Sent: Thursday, May 10, 2001 4:04 AM
Subject: [access] Uppercasing (is that a word?)
> Hi,
>
> Does anyone know a way to force all the lowercase data in an Access tables
> records to uppercase.
>
> Thanks in advance.....
>
Message #3 by "Rogers, Robert" <rrogers@b...> on Thu, 10 May 2001 08:22:28 -0400
|
|
In table disign view put a ">" in format.
Robert L. Rogers
Application Developer, Rexel Branch Electric
(xxx)-xxx-xxxx
-----Original Message-----
From: Bob Bedell [mailto:bdbedell@m...]
Sent: Thursday, May 10, 2001 12:04 AM
To: Access
Subject: [access] Uppercasing (is that a word?)
Hi,
Does anyone know a way to force all the lowercase data in an Access tables
records to uppercase.
Thanks in advance.....
Message #4 by "Kostenko, Ludmilla A." <LKostenko@s...> on Thu, 10 May 2001 08:52:40 -0400
|
|
Hi,
Use UCase(field_name).
Thanks,
Ludmilla
-----Original Message-----
From: Bob Bedell [mailto:bdbedell@m...]
Sent: Thursday, May 10, 2001 12:04 AM
To: Access
Subject: [access] Uppercasing (is that a word?)
Hi,
Does anyone know a way to force all the lowercase data in an Access tables
records to uppercase.
Thanks in advance.....
Message #5 by "Levine, Lloyd" <LEVINLL@m...> on Thu, 10 May 2001 06:01:43 -0700
|
|
Set the format property of the field you want to be uppercase to >
-----Original Message-----
From: Bob Bedell [mailto:bdbedell@m...]
Sent: Thursday, May 10, 2001 12:04 AM
To: Access
Subject: [access] Uppercasing (is that a word?)
Hi,
Does anyone know a way to force all the lowercase data in an Access tables
records to uppercase.
Thanks in advance.....
|
|
|
View Cart
