Formatting text in a report

  • Thread starter Thread starter Gerry Duggan
  • Start date Start date
G

Gerry Duggan

I was recently asked to consolidate several tables
prepared by others in one database. I imported the tables
with no problem however one particular table had all the
data in one of the text fields (i.e. Field - Name of City)
in upper case. I would like to design a report including
this field but I would like to convert the text case in
the Name of City field to upper case for the first letter
in each word and lower for the rest. I tried putting in a
mask in the format section of the object properties with
no success.

Would appreciate any suggestions.

Regards,

Gerry
 
I was recently asked to consolidate several tables
prepared by others in one database. I imported the tables
with no problem however one particular table had all the
data in one of the text fields (i.e. Field - Name of City)
in upper case. I would like to design a report including
this field but I would like to convert the text case in
the Name of City field to upper case for the first letter
in each word and lower for the rest. I tried putting in a
mask in the format section of the object properties with
no success.

Would appreciate any suggestions.

Regards,

Gerry
Click to expand...

Add an unbound control to the report.
Set it's control source to:
=StrConv([CityField],3)

Make sure the name of this control is not "CityField".
 
Fred :

Your suggestion worked perfectly.

Thank you,

Gerry
-----Original Message-----
I was recently asked to consolidate several tables
prepared by others in one database. I imported the tables
with no problem however one particular table had all the
data in one of the text fields (i.e. Field - Name of City)
in upper case. I would like to design a report including
this field but I would like to convert the text case in
the Name of City field to upper case for the first letter
in each word and lower for the rest. I tried putting in a
mask in the format section of the object properties with
no success.

Would appreciate any suggestions.

Regards,

Gerry
Click to expand...

Add an unbound control to the report.
Set it's control source to:
=StrConv([CityField],3)

Make sure the name of this control is not "CityField".


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top