Changing Format Depending Upon Criteria

  • Thread starter Thread starter Kitty
  • Start date Start date
K

Kitty

I have a report that shows three conditions for each
record. Those conditions are either Y or N.

The report is showing the results of an independent
verification of those conditions; i.e., did the branch
assign the proper code.

The users of the report want the correct codes to be in
lower case, and the incorrect codes to be in upper case
and bold. They want to see the three codes that were
assigned by the branch with an indication of their
accuracy.

There is a field in the underlying table that indicates if
the conditions are correct. That field is completed by
the independent reviewers. I'm using the field to control
the bolding if the Y or N (an if statement in the
Detail_Print event).

How can I change the case at print time? Or can't I?

Thanks for your help.
 
on the "On Format" event of the detail section use this code

if condition Y then
let field.FontSize=8
else
let field.FontSize=12
endif
 
Thanks, JoeElla.

What I want to do is change an N to an n or a Y to a y. I
don't want to change the size of the letters, just their
case.

Thanks.
 
Kitty,
You can do that by using the LCASE or UCASE functions and using an
unbound text box to display the results.
 
Back
Top