Conditional statement in a Report Field ??

[Will]

rptDemo is built on qryDemo

Here is what I would like to know how to do in the report...

If [Prime Location] = True Then Display "True"

1 - Can you put statements directly into a field in a Report?
2 - If so what is the correct syntax?
3 - If no then how?

Thanks for any help.

 

[Douglas J. Steele]

Set the text box's control source to

=IIf([Prime Location] True, "True", "")

(including the equal sign)

Alternatively, bind the text box to the Prime Location field, and set its
format to

;True;

(that's a semi-colon before and after the word True)

 

[Will]

What if we want about these 2 cases?

If [status]="declined" then display "DECLINED SO IGNORE THIS ACCOUNT]

or this caes...

If [status] = "declined' then set FontWeight = Bold

Hopefully with these two additional examples I will be able to have enough
to figgure out syntax for other cases.

Thanks for the help

Set the text box's control source to

=IIf([Prime Location] True, "True", "")

(including the equal sign)

Alternatively, bind the text box to the Prime Location field, and set its
format to

;True;

(that's a semi-colon before and after the word True)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

rptDemo is built on qryDemo

Here is what I would like to know how to do in the report...

If [Prime Location] = True Then Display "True"

1 - Can you put statements directly into a field in a Report?
2 - If so what is the correct syntax?
3 - If no then how?

Thanks for any help.

 

[Douglas J. Steele]

First, I noticed that there was an error in what I posted earlier. It should
be

=IIf([Prime Location] = True, "True", "")

or

=IIf([Prime Location], "True", "")

Now to your new questions.

For the first, it would be

=IIf([status] = "declined", "DECLINED SO IGNORE THIS ACCOUNT!", "")

You can't use an IIf statement to set font weight. Look into Conditional
Formating for that.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What if we want about these 2 cases?

If [status]="declined" then display "DECLINED SO IGNORE THIS ACCOUNT]

or this caes...

If [status] = "declined' then set FontWeight = Bold

Hopefully with these two additional examples I will be able to have enough
to figgure out syntax for other cases.

Thanks for the help

Set the text box's control source to

=IIf([Prime Location] True, "True", "")

(including the equal sign)

Alternatively, bind the text box to the Prime Location field, and set its
format to

;True;

(that's a semi-colon before and after the word True)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

rptDemo is built on qryDemo

Here is what I would like to know how to do in the report...

If [Prime Location] = True Then Display "True"

1 - Can you put statements directly into a field in a Report?
2 - If so what is the correct syntax?
3 - If no then how?

Thanks for any help.

 

[Will]

Thanks Doug. Great info... as always.

First, I noticed that there was an error in what I posted earlier. It
should be

=IIf([Prime Location] = True, "True", "")

or

=IIf([Prime Location], "True", "")

Now to your new questions.

For the first, it would be

=IIf([status] = "declined", "DECLINED SO IGNORE THIS ACCOUNT!", "")

You can't use an IIf statement to set font weight. Look into Conditional
Formating for that.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What if we want about these 2 cases?

If [status]="declined" then display "DECLINED SO IGNORE THIS ACCOUNT]

or this caes...

If [status] = "declined' then set FontWeight = Bold

Hopefully with these two additional examples I will be able to have
enough to figgure out syntax for other cases.

Thanks for the help

Set the text box's control source to

=IIf([Prime Location] True, "True", "")

(including the equal sign)

Alternatively, bind the text box to the Prime Location field, and set
its format to

;True;

(that's a semi-colon before and after the word True)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


rptDemo is built on qryDemo

Here is what I would like to know how to do in the report...

If [Prime Location] = True Then Display "True"

1 - Can you put statements directly into a field in a Report?
2 - If so what is the correct syntax?
3 - If no then how?

Thanks for any help.