Conditional Text within Paragraph

[Arndres]

I have a paragraph in a access form letter report where I need to enter a
conditional line of text I have entered the following formula:
="Once enrolled in our plan, you can only make changes during certain times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan " & IIf([group number]<>"M15628"," that
has prescription drug coverage.") Or IIf([group number]="M59815"," that does
not have prescription drug coverage.") & "Between November.... ")

However it accepts this argument but it does not display the conditional text.

Please help Thanks

 

[Douglas J. Steele]

="Once enrolled in our plan, you can only make changes during certain times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan" & IIf([group number]<>"M15628"," that
has prescription drug coverage.", IIf([group number]="M59815"," that does
not have prescription drug coverage.", Null) & " between November.... "

 

[Arndres]

Hi Douglas,

This still does not work. We are using Access 2002. What do you think is
the problem.

="Once enrolled in our plan, you can only make changes during certain times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan" & IIf([group number]<>"M15628"," that
has prescription drug coverage.", IIf([group number]="M59815"," that does
not have prescription drug coverage.", Null) & " between November.... "


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a paragraph in a access form letter report where I need to enter a
conditional line of text I have entered the following formula:
="Once enrolled in our plan, you can only make changes during certain
times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan " & IIf([group number]<>"M15628","
that
has prescription drug coverage.") Or IIf([group number]="M59815"," that
does
not have prescription drug coverage.") & "Between November.... ")

However it accepts this argument but it does not display the conditional
text.

Please help Thanks

 

[Douglas J. Steele]

What does "does not work" mean? Does something show, but not what you think
should be showing?

Personally, I think you'd be better off using VBA code in the Format event
of whatever section the text is to appear in, or else put the code in the
query upon which the report is based.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Douglas,

This still does not work. We are using Access 2002. What do you think is
the problem.

="Once enrolled in our plan, you can only make changes during certain
times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan" & IIf([group number]<>"M15628","
that
has prescription drug coverage.", IIf([group number]="M59815"," that does
not have prescription drug coverage.", Null) & " between November.... "


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I have a paragraph in a access form letter report where I need to enter
a
conditional line of text I have entered the following formula:
="Once enrolled in our plan, you can only make changes during certain
times
of the year. Between January and August, you have an opportunity to
make
changes, but you can only join a plan " & IIf([group
number]<>"M15628","
that
has prescription drug coverage.") Or IIf([group number]="M59815"," that
does
not have prescription drug coverage.") & "Between November.... ")

However it accepts this argument but it does not display the
conditional
text.

Please help Thanks

 

[Arndres]

Hi,

I apologize for the delay I got this to work. Thank you very much for your
help. I had put in the formula incorrectly.

What does "does not work" mean? Does something show, but not what you think
should be showing?

Personally, I think you'd be better off using VBA code in the Format event
of whatever section the text is to appear in, or else put the code in the
query upon which the report is based.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Douglas,

This still does not work. We are using Access 2002. What do you think is
the problem.

="Once enrolled in our plan, you can only make changes during certain
times
of the year. Between January and August, you have an opportunity to make
changes, but you can only join a plan" & IIf([group number]<>"M15628","
that
has prescription drug coverage.", IIf([group number]="M59815"," that does
not have prescription drug coverage.", Null) & " between November.... "


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a paragraph in a access form letter report where I need to enter
a
conditional line of text I have entered the following formula:
="Once enrolled in our plan, you can only make changes during certain
times
of the year. Between January and August, you have an opportunity to
make
changes, but you can only join a plan " & IIf([group
number]<>"M15628","
that
has prescription drug coverage.") Or IIf([group number]="M59815"," that
does
not have prescription drug coverage.") & "Between November.... ")

However it accepts this argument but it does not display the
conditional
text.

Please help Thanks