Sentence Case

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hello.

I have a database with about 3000 records. In one of the
fields, 'City', the data was initially entered in in all
caps (e.g. PROVIDENCE). Is there a way to write a query
that can change this field's text into sentence case
(Providence)?

Thanks in advance,

m
 
Short and to the point...thanks! Worked like a charm.

One other quick question. How or can I make it so that it
actually converts the data in the actual table to sentence
case...trying to avoid having to go through all my
reports/forms and add this new field.

Thanks again.

m.
-----Original Message-----

hi,

strconv([field],3)

-----Original Message-----
Hello.

I have a database with about 3000 records. In one of the
fields, 'City', the data was initially entered in in all
caps (e.g. PROVIDENCE). Is there a way to write a query
that can change this field's text into sentence case
(Providence)?

Thanks in advance,

m
.
Click to expand...
.
Click to expand...
 
Short and to the point...thanks! Worked like a charm.

One other quick question. How or can I make it so that it
actually converts the data in the actual table to sentence
case...trying to avoid having to go through all my
reports/forms and add this new field.

Thanks again.

m.
-----Original Message-----

hi,

strconv([field],3)

-----Original Message-----
Hello.

I have a database with about 3000 records. In one of the
fields, 'City', the data was initially entered in in all
caps (e.g. PROVIDENCE). Is there a way to write a query
that can change this field's text into sentence case
(Providence)?

Thanks in advance,

m
.
Click to expand...
.
Click to expand...
Click to expand...

Run an update query:

Update YourTable Set YourTable.FieldName = UCase([FieldName],3) Where
YourTable.FieldName is Not Null;

Words that should contain more than one (or no) capital letter will
not be correctly changed, i.e. IBM will become Ibm, ABC Broadcasting
becomes Abc Broadcasting, McDaniels becomes Mcdaniels, van den Steen
becomes Van Den Steen, etc.
 
You could always run an update query on all the fields you
want to change to Title Case (note the term "Title Case".
Sentence case capitalizes the first letter of the first
work of the sentence. Title Case Will Capitalize The First
Letter Of Each Word.)

Good luck,
-M

-----Original Message-----
Short and to the point...thanks! Worked like a charm.

One other quick question. How or can I make it so that it
actually converts the data in the actual table to sentence
case...trying to avoid having to go through all my
reports/forms and add this new field.

Thanks again.

m.
-----Original Message-----

hi,

strconv([field],3)

-----Original Message-----
Hello.

I have a database with about 3000 records. In one of the
fields, 'City', the data was initially entered in in all
caps (e.g. PROVIDENCE). Is there a way to write a query
that can change this field's text into sentence case
(Providence)?

Thanks in advance,

m
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
One other quick question. How or can I make it so that it
actually converts the data in the actual table to sentence
case...trying to avoid having to go through all my
reports/forms and add this new field.
Click to expand...

Run an Update query updating the field to the Strconv() expression.
 
Back
Top