Need Help w/UCase in Reports

[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

 

[JerryDennison]

UPC does not support Alpha characters. Are you sure you're using UPC? Which flavor? A/C/E? Code 6of9 (sometimes called Code 69), 128, and a few others support alpha but UPC doesn't.

 

[kevinwilson]

Jerry,
The bar code font is: Code 3of9 or "Code39". Hope this helps.

 

[JerryDennison]

Oops, I meant Code 39. Sorry, musta had something else on my brain. Anyway, this code does support alpha-numeric characters. It doesn't matter if they're upper case or not. Anyway, to insure that the field prints all uppercase add the following to the control's Format property:

>

 

[Lozere]

Are you sure that the callbarcode function is typed "String"?

What don't you use the Uppercase function:

=UpperCase(Callbarcode(UPC_Code))
Appears too simple-Does I miss a step?

 

[kevinwilson]

Hi all,
Here's what I ended up using:

=callbarcode(UCase([UPC Code]))

Worked great!

Thanks again for all of your help.
Aloha,
~kevin