change case

[kunalnp_dsfs]

Respected Sir,
With ref. to above subject here i have tried to explain my problem. i hope
for reply and oblige.

1. I wish to change my text format in my database.
my database fields which are text type stored in capital case formate
instead of that i wish to change them into Title case but i could not find
any option in access to change case facility.

i wish to make a query or any code which can update my text capital case to
title case or all capital(upper) case to lower case, lower case to upper case
or any both of them into Title case.

Please suggest me if there is option in access which i did not found through
Access Help.

and one more thing in access i would like to ask that...

2. Access database has option(facility) to make crosstab query but it can
not support in report option.
we wish there should be a option(facility) to create a report by Crosstab
Report like othe option.

 

[Steve Schapel]

Kunalnp_dsfs,

1. The function in Access to change case of text is the StrConv()
function. For example, you can run an Update Query to update [YourText]
to StrConv([YourText],3) which will change it to proper case. You
should be able to find a Help topic on this.

2. Normally it is reasonably straightforward to build a Report based on
a Crosstab Query. There are several Help topics which relate to this,
including one titled: "Create a crosstab report with fixed-column headings".

 

[John Vinson]

Respected Sir,
With ref. to above subject here i have tried to explain my problem. i hope
for reply and oblige.

1. I wish to change my text format in my database.
my database fields which are text type stored in capital case formate
instead of that i wish to change them into Title case but i could not find
any option in access to change case facility.

i wish to make a query or any code which can update my text capital case to
title case or all capital(upper) case to lower case, lower case to upper case
or any both of them into Title case.

The VBA function StrConv() can do this for you.

It takes two arguments: the string to be converted, and the desired
output. 1 is lower case, 2 is UPPER CASE, 3 is Proper Case (Every Word
Capitalized), and there are other options for other languages. To
convert a field named MyField from ALL CAPS to Proper Case, create an
Update query and on the Update To line put

StrConv([MyField], 3)

The [brackets] are required! If you leave them off, it will update
every record in the table to "Myfield". Make a backup copy of your
database first just to be safe! Use 1 for lower case, 2 for UPPER CASE
if you need to do so.

Please suggest me if there is option in access which i did not found through
Access Help.

It's NOT obvious in the online help; the help indexing is very badly
done, unfortunately.

and one more thing in access i would like to ask that...

2. Access database has option(facility) to make crosstab query but it can
not support in report option.
we wish there should be a option(facility) to create a report by Crosstab
Report like othe option.

You can base a Report on a crosstab query; are you having a specific
problem doing so? Create the query first and then use the Report
Wizard.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps