Printing upper case mailing labels.

[Chuck]

I have just recently begun using Access 2000. I set up a
database which has one table (primarily names and
addresses). In the form I created for data entry, I chose
to have the text automatically change text to upper case
as I move from field to field. In the associated table,
the text appears in upper case. In a routine report that
uses the table, the text prints in upper case. However,
when I use the Label Wizard to to create mailing labels,
the text appears entirely in lower case. What gives? How
do I get the labels to print in upper case. Thanks very
much for your help.

 

[fredg]

I have just recently begun using Access 2000. I set up a
database which has one table (primarily names and
addresses). In the form I created for data entry, I chose
to have the text automatically change text to upper case
as I move from field to field. In the associated table,
the text appears in upper case. In a routine report that
uses the table, the text prints in upper case. However,
when I use the Label Wizard to to create mailing labels,
the text appears entirely in lower case. What gives? How
do I get the labels to print in upper case. Thanks very
much for your help.

In the Format property of the control type >

Also, look up the UCase function in VBA help.

 

[chuckb]

-----Original Message-----


In the Format property of the control type >

Also, look up the UCase function in VBA help.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Thanks for your help, Fred. Unfortunately, I am an

unsophisticated Access user and simply can't find where I
type the > to turn all the data into upper case. I have
been in DesignView for the report and can get to
Conditional Formatting, but then I'm lost.

 

[fredg]

unsophisticated Access user and simply can't find where I
type the > to turn all the data into upper case. I have
been in DesignView for the report and can get to
Conditional Formatting, but then I'm lost.

Open the report in Design View.
Select the CONTROL's. (The ones that say something like
=Trim([ClientName]), etc.)
(You can select each control as a group by holding down the Shift key
as you click on them.)
Display the control's property sheet.
Click on the Format tab.
The first item is Format.
Typeon that line.
Save the change. Run the report.

Alternatively, you can change each control's control source from:
=Trim([FieldName])
to
=UCase(Trim([FieldName]))

This would need to be done in each control, one at a time.

 

[chuckb]

-----Original Message-----

up
a gives?
How
unsophisticated Access user and simply can't find where I
type the > to turn all the data into upper case. I have
been in DesignView for the report and can get to
Conditional Formatting, but then I'm lost.

Open the report in Design View.
Select the CONTROL's. (The ones that say something like
=Trim([ClientName]), etc.)
(You can select each control as a group by holding down the Shift key
as you click on them.)
Display the control's property sheet.
Click on the Format tab.
The first item is Format.
Typeon that line.
Save the change. Run the report.

Alternatively, you can change each control's control source from:
=Trim([FieldName])
to
=UCase(Trim([FieldName]))

This would need to be done in each control, one at a time.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Thanks again, Fred. I'll try this when I get home. I

assume that I "display the control's property sheet" by
clicking on VIEW (where Conditional Formatting also
appears), then clicking on Format, then clicking on the
Format tab. I won't be near the internet until Tues.
I'll let you know if I finally "got it."

 

[fredg]

Thanks for your help, Fred. Unfortunately, I am an
unsophisticated Access user and simply can't find where I
type the > to turn all the data into upper case. I have
been in DesignView for the report and can get to
Conditional Formatting, but then I'm lost.

Open the report in Design View.
Select the CONTROL's. (The ones that say something like
=Trim([ClientName]), etc.)
(You can select each control as a group by holding down the Shift key
as you click on them.)
Display the control's property sheet.
Click on the Format tab.
The first item is Format.
Typeon that line.
Save the change. Run the report.

Alternatively, you can change each control's control source from:
=Trim([FieldName])
to
=UCase(Trim([FieldName]))

This would need to be done in each control, one at a time.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Thanks again, Fred. I'll try this when I get home. I

assume that I "display the control's property sheet" by
clicking on VIEW (where Conditional Formatting also
appears), then clicking on Format, then clicking on the
Format tab. I won't be near the internet until Tues.
I'll let you know if I finally "got it."

Regarding: "display the control's property sheet" by

clicking on VIEW (where Conditional Formatting also
appears), then clicking on Format, then clicking on the
Format tab.

NO!
The Conditional Formatting is under the Format Menu tool bar.
That's NOT where you want to be.

Open the Report in Design View.
The control is the box within the report's detail section.
It will say something like
=Trim([SomeName])
= Trim([Address])
= Trim([[City] etc)
etc.
To display the control's property sheet, right-click on that control.
Select Properties from the drop-down menu.
Then click on THAT property sheet's Format tab. The first property on
that tab is the control's Format property.
That's where you enter the > symbol.