converting uppercase to proper case

[Susan]

One of our database users has input all her data (names)
using all caps. In looking through the Help file (Access
97) I found a reference to a StrConv function that uses
vcProperCase to convert the first letter to upper case and
the rest lower case. Can this be used to convert existing
data, or just to prevent this in any new data? Is this
want we want to use, or must the guilty party change all
her data by hand? If this IS what we want to use, I must
confess that I am a novice and have NO idea how/where to
use this function. Any help would be appreciated.

PS - actually it would even be OK if the actual data stays
all in caps, just so it is displayed in the form and the
reports the correct way. Is this an option?

Thanks!

 

[Cheryl Fischer]

Susan,

You can correct this data using the StrConv() function in an Update Query,
as follows:

1. From the Database Window, select Queries, then New
2. Select the table
3. When the query's design grid opens, select Query from the menu, then
Update Query
4. Drag the field to be updated to the Field: row of the first empty
column
5. In the Update to: row, insert the following:

StrConv([MyField], 3)

6. If there is a field in your table that will identify all of this
person's records, drag it to another column. Do not put anything in the
Update to: row, but enter the expression that will identify her records in
the Criteria: row.

Change MyField to the name of your field.

hth,

 

[Susan]

WOW...great! Thanks loads, Cheryl! I'll let the user
know she "lucked out" on this one!

-----Original Message-----
Susan,

You can correct this data using the StrConv() function in an Update Query,
as follows:

1. From the Database Window, select Queries, then New
2. Select the table
3. When the query's design grid opens, select Query from the menu, then
Update Query
4. Drag the field to be updated to the Field: row of the first empty
column
5. In the Update to: row, insert the following:

StrConv([MyField], 3)

6. If there is a field in your table that will identify all of this
person's records, drag it to another column. Do not put anything in the
Update to: row, but enter the expression that will identify her records in
the Criteria: row.

Change MyField to the name of your field.

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

One of our database users has input all her data (names)
using all caps. In looking through the Help file (Access
97) I found a reference to a StrConv function that uses
vcProperCase to convert the first letter to upper case and
the rest lower case. Can this be used to convert existing
data, or just to prevent this in any new data? Is this
want we want to use, or must the guilty party change all
her data by hand? If this IS what we want to use, I must
confess that I am a novice and have NO idea how/where to
use this function. Any help would be appreciated.

PS - actually it would even be OK if the actual data stays
all in caps, just so it is displayed in the form and the
reports the correct way. Is this an option?

Thanks!

.

 

[Cheryl Fischer]

Make her sweat for a while <smile>!

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

WOW...great! Thanks loads, Cheryl! I'll let the user
know she "lucked out" on this one!

-----Original Message-----
Susan,

You can correct this data using the StrConv() function in an Update Query,
as follows:

1. From the Database Window, select Queries, then New
2. Select the table
3. When the query's design grid opens, select Query from the menu, then
Update Query
4. Drag the field to be updated to the Field: row of the first empty
column
5. In the Update to: row, insert the following:

StrConv([MyField], 3)

6. If there is a field in your table that will identify all of this
person's records, drag it to another column. Do not put anything in the
Update to: row, but enter the expression that will identify her records in
the Criteria: row.

Change MyField to the name of your field.

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

One of our database users has input all her data (names)
using all caps. In looking through the Help file (Access
97) I found a reference to a StrConv function that uses
vcProperCase to convert the first letter to upper case and
the rest lower case. Can this be used to convert existing
data, or just to prevent this in any new data? Is this
want we want to use, or must the guilty party change all
her data by hand? If this IS what we want to use, I must
confess that I am a novice and have NO idea how/where to
use this function. Any help would be appreciated.

PS - actually it would even be OK if the actual data stays
all in caps, just so it is displayed in the form and the
reports the correct way. Is this an option?

Thanks!

.

 

[Lynn Trapp]

Oh you are cruel... <grin>

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Make her sweat for a while <smile>!

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

WOW...great! Thanks loads, Cheryl! I'll let the user
know she "lucked out" on this one!

-----Original Message-----
Susan,

You can correct this data using the StrConv() function in an Update Query,
as follows:

1. From the Database Window, select Queries, then New
2. Select the table
3. When the query's design grid opens, select Query from the menu, then
Update Query
4. Drag the field to be updated to the Field: row of the first empty
column
5. In the Update to: row, insert the following:

StrConv([MyField], 3)

6. If there is a field in your table that will identify all of this
person's records, drag it to another column. Do not put anything in the
Update to: row, but enter the expression that will identify her records in
the Criteria: row.

Change MyField to the name of your field.

hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


One of our database users has input all her data (names)
using all caps. In looking through the Help file (Access
97) I found a reference to a StrConv function that uses
vcProperCase to convert the first letter to upper case and
the rest lower case. Can this be used to convert existing
data, or just to prevent this in any new data? Is this
want we want to use, or must the guilty party change all
her data by hand? If this IS what we want to use, I must
confess that I am a novice and have NO idea how/where to
use this function. Any help would be appreciated.

PS - actually it would even be OK if the actual data stays
all in caps, just so it is displayed in the form and the
reports the correct way. Is this an option?

Thanks!


.