Eliminating a space in a report

[Rockape]

Hi,

I would like to know whether the following routine is possible.


(I am using A97)!

I have a table of addresses:-
A1
A2
A3
Country

There are occasions when the address is so short that Address 3 (A3) is not required even though the country field is filled in.

I also have a report which picks all four addresses. However, given the above, when I print the report, there is a blank gap in the address3 .

I was wondering whether itis possible to avoid that.

the report instead of looking like:-

John Doe
Apt1 Block3
A3
England

would become:

John Doe
Apt1 Block3
England


Thanks

 

[vbaInet]

Set the Can Grow and Can Shrink properties of all four address controls to Yes.

 

[Rockape]

Hi ,

Just done that but the problem remains!!

 

[vbaInet]

Change the Control Source of address 3 to:

=IIF(Len([[COLOR=Red]Address3[/COLOR]] & "") = 0, Null, [[COLOR=Red]Address3[/COLOR]])

Substitute Address3 for the correct field name. Then run the report to see if Address3 is shrunk.

 

[spikepl]

http://office.microsoft.com/en-us/a...-lines-in-labels-and-reports-HA001149472.aspx

 

[Rockape]

Hi,

No I get an error in that field now when preview the report!

By the way do you mean changing the Contol Source of the field Address 3 in the report?

 

[vbaInet]

By the way do you mean changing the Contol Source of the field Address 3 in the report?

Yes, just the Control Source.

 

[Rockape]

Hi,

That's not working either. Please note I am using A97.

Can anyone amend whet I uploaded to see if it works?

Thanks

 

[vbaInet]

You will find that a lot of us don't have 97. You really need to start thinking of upgrading pretty soon.

Anyway, each field has a label next to it. You textbox is shrinking but the label isn't.

Get rid of the label and it should shrink as advised in my first post.

 

[Rockape]

Hi,

yes Certainly will...mind you the link provided by Spikepl was also quite useful..

Finally found sample database in

http://support.microsoft.com/kb/175072

Your reasoning also helped quite a lot...

Many thanks to all.

 

[vbaInet]

Happy to hear Rockape!