simple problem with report

[Rex]

Hi

I am trying to create reports (letters) where in I want to print a
particular paragraph based on the value of a textbox.. for e.g if the
value of a textboxA is null or is empty I want to show paragraph1 and
if the value of the textboxA is not empty or is not null then I want to
show paragraph2

There are lots of records where textboxA would be empty for some and
not empty for others.

I have tried the Details_Format() function for this but it doesnt seem
to work..

can you tell me where I am going wrong..

cheers
Rex

 

[Guest]

Hi Rex,

Assuming Paragraph1 and Paragraph2 are fields in the table behind your
report, you could use something like iif(isnull(forms!FORMNAME.textboxA),
[Paragraph1], [Paragraph2])

Hope that helps.

Damian.

 

[Rex]

Thanks Damian.. it worked..

Hi Rex,

Assuming Paragraph1 and Paragraph2 are fields in the table behind your
report, you could use something like iif(isnull(forms!FORMNAME.textboxA),
[Paragraph1], [Paragraph2])

Hope that helps.

Damian.

Hi

I am trying to create reports (letters) where in I want to print a
particular paragraph based on the value of a textbox.. for e.g if the
value of a textboxA is null or is empty I want to show paragraph1 and
if the value of the textboxA is not empty or is not null then I want to
show paragraph2

There are lots of records where textboxA would be empty for some and
not empty for others.

I have tried the Details_Format() function for this but it doesnt seem
to work..

can you tell me where I am going wrong..

cheers
Rex