Field promotion in a Report.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joergen Bondesen - 18 Jan 2008 22:13 GMT

Hi NG.

I have a Table - Quiery an a Report.
The Reports contain fields:

First_Lastname
Adr1
Adr2
ZipCity

If this was mailmerge in Word and Adr2 field was empty I would have this
information in the letter:

First_Lastname
Adr1
ZipCity

Is it possible to do so in the Report?

Signature

Best Regards from
Joergen Bondesen

Reply to this Message

fredg - 18 Jan 2008 22:45 GMT

> Hi NG.
>
[quoted text clipped - 14 lines]
>
> Is it possible to do so in the Report?

You could set the [Adr2] control's CanShink property to Yes.
If no other control is on the same line, the ZipCity will move up.
or...
What do you wish to do if Adr2 is not empty?
Show both addresses?
Use an Unbound text control instead of the 2 bound text controls.
Set it's control source to:
=IIf(IsNull([Adr2]),[Adr1],[Adr1] & chr(13) & Chr(10) & [Adr2])

or...
Show Adr2 only if Adr1 is empty?
= IIf(IsNull([Adr1]),[Adr2],[Adr1])

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Joergen Bondesen - 19 Jan 2008 09:46 GMT

Hi Fred

Thanks.

The magic word I was looking for was: CanShink

Signature

Best Regards from
Joergen Bondesen

>> Hi NG.
>>
[quoted text clipped - 27 lines]
> Show Adr2 only if Adr1 is empty?
> = IIf(IsNull([Adr1]),[Adr2],[Adr1])

Reply to this Message