UCase in Reports: Can this work?

[kevinwilson]

Aloha All,
Well after a few hours searching through these pages here I am hoping someone can enlighten me on a seemingly simple problem.

I am trying to modify a report that prints (ASCII) UPC codes. I believe ASCII is case sensitive and that's why I'm having trouble printing bar codes. To remedy this I want to convert all text on the report to ALL CAPS including the [UPC Code] field.

My fields are: Desc., Mfg., ItemNum., SerialNum., ModelNum., and [UPC Code].

I placed the ">" in the Format field in the Properties box for all the fields listed above so that my labels(report) would print in ALL CAPS. This works fine for all fields except the [UPC Code] field.

The Control Souce for all fields come from the same underlying table, however the Control Source for the [UPC Code] looks like this: =callbarcode([UPC Code])

How and can I "Format" the [UPC Code] field in a report that would force ALL CAPS?

I am trying to resolve this on the "Report" end of my application to minimize the task of updating and redistributing my application file to over a dozen users in several countries!

Many Mahalo's to anyone and everyone who can shed some light on this.

~kevin

 

[hermanlaksko]

Hi Kevin

Did you try:

control source: =format(callbarcode([UPC Code])">&quot

 

[CID8]

This should work if the previous answer doesn't.

In the record source for the report change [UPC Code] to UCase([UPC Code]) AS UPC.

CID8

 

[kevinwilson]

Much much aloha to you all!

Without your help I would have never figured this one out. Here's my resolve. I placed the following code in the "Control Source" field in Properties and it works like a charm.

=callbarcodes(UCase([UPC Code]))

Next time in Hawaii drop me a line and we'll go scan some bar codes!

Mahalo nui loa,
~kevin