Font change upon conditions.

[Sony]

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

 

[fredg]

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

You won't be able to do this using one text control.
A text control can only be in one fontstyle.

So, add an unbound control to your report.
Set it's control source to:
=IIf([FormControl]<56,"-",IIf([SomeControl]>76,"+","")
Name this control "PlusMinus".

Add another unbound control to the report.
Set it's Font to Wingdings.
Set it's control source to
=Chr(253)
Make it Not Visible
Name this control "MyCheck"
Place it directly over the other control so it will print in the
correct position.
Size both control's to whatever size you want.

Code the Detail Format event:
MyCheck.Visible = [SomeControl]>56 and [SomeControl]<76

Only a -, +, or Check mark will print.

 

[Sony]

Thanks but it didn't work for me. All I get is Text:23. The values are being
generated from a query. Based upon the totals of scores I would like for the
report to generate a check, " + ", or " - ". I don't know if this information
will help you help me or not, I hope so.

Thank you,
Sony

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

You won't be able to do this using one text control.
A text control can only be in one fontstyle.

So, add an unbound control to your report.
Set it's control source to:
=IIf([FormControl]<56,"-",IIf([SomeControl]>76,"+","")
Name this control "PlusMinus".

Add another unbound control to the report.
Set it's Font to Wingdings.
Set it's control source to
=Chr(253)
Make it Not Visible
Name this control "MyCheck"
Place it directly over the other control so it will print in the
correct position.
Size both control's to whatever size you want.

Code the Detail Format event:
MyCheck.Visible = [SomeControl]>56 and [SomeControl]<76

Only a -, +, or Check mark will print.

 

[Sony]

I can generat a "+" and "-" right from the query design view, is there a
string, code or statement that I can make in the query to gerate a check mark?

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

You won't be able to do this using one text control.
A text control can only be in one fontstyle.

So, add an unbound control to your report.
Set it's control source to:
=IIf([FormControl]<56,"-",IIf([SomeControl]>76,"+","")
Name this control "PlusMinus".

Add another unbound control to the report.
Set it's Font to Wingdings.
Set it's control source to
=Chr(253)
Make it Not Visible
Name this control "MyCheck"
Place it directly over the other control so it will print in the
correct position.
Size both control's to whatever size you want.

Code the Detail Format event:
MyCheck.Visible = [SomeControl]>56 and [SomeControl]<76

Only a -, +, or Check mark will print.

 

[fredg]

Thanks but it didn't work for me. All I get is Text:23. The values are being
generated from a query. Based upon the totals of scores I would like for the
report to generate a check, " + ", or " - ". I don't know if this information
will help you help me or not, I hope so.

Thank you,
Sony

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

You won't be able to do this using one text control.
A text control can only be in one fontstyle.

So, add an unbound control to your report.
Set it's control source to:
=IIf([FormControl]<56,"-",IIf([SomeControl]>76,"+","")
Name this control "PlusMinus".

Add another unbound control to the report.
Set it's Font to Wingdings.
Set it's control source to
=Chr(253)
Make it Not Visible
Name this control "MyCheck"
Place it directly over the other control so it will print in the
correct position.
Size both control's to whatever size you want.

Code the Detail Format event:
MyCheck.Visible = [SomeControl]>56 and [SomeControl]<76

Only a -, +, or Check mark will print.

There would be no reason for the control to say Text:23 from the
information you have given. You must have incorrectly written the
control source code. Look at my reply again.

 

[Sony]

Okay,
I will try again. Do I need to take the information I put in the query out
first or will it make any difference?

I can generat a "+" and "-" right from the query design view, is there a
string, code or statement that I can make in the query to gerate a check mark?

On Tue, 13 Dec 2005 14:45:02 -0800, Sony wrote:

For a value below 56 I would like for a " - " to appear in the report, for
values above 76 I would like for a " + " to apear, for any other numbers I
would like for a check mark to be displayed. The check mark is a capital "P"
in wingdings 2. Does anyone know how to display a check mark in a report?

Thanks

You won't be able to do this using one text control.
A text control can only be in one fontstyle.

So, add an unbound control to your report.
Set it's control source to:
=IIf([FormControl]<56,"-",IIf([SomeControl]>76,"+","")
Name this control "PlusMinus".

Add another unbound control to the report.
Set it's Font to Wingdings.
Set it's control source to
=Chr(253)
Make it Not Visible
Name this control "MyCheck"
Place it directly over the other control so it will print in the
correct position.
Size both control's to whatever size you want.

Code the Detail Format event:
MyCheck.Visible = [SomeControl]>56 and [SomeControl]<76

Only a -, +, or Check mark will print.

No!
The method I gave you earlier works. You can generate your + or - in
the query, however to get the check mark in the report you will need
to use an unbound control, wingdings, and the code in the Detail
format event to make the check mark visible or not. In this case adapt
the code so that it makes the check box visible when the other control
is not "-" or "+".