By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Shrink Field

P: n/a
I am trying to make addresses print on a report. I have two fields
for the street address, how do I make the second field not leave an
empty space on the report? I want the city, state, zip to print right
under the first address field if the second address field is null.

Thanks.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Karen,

Set the Can Shrink property of Address2 to Yes. You can't have anything to
the right of Address2 for this to work.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Karen" <kr****@portlite.com> wrote in message
news:50**************************@posting.google.c om...
I am trying to make addresses print on a report. I have two fields
for the street address, how do I make the second field not leave an
empty space on the report? I want the city, state, zip to print right
under the first address field if the second address field is null.

Thanks.

Nov 13 '05 #2

P: n/a
Hi Karen,

Open the report in design mode. Right click on that second field to open
the properties window and set "Can Shrink" = Yes.

HTH -Linda
"Karen" <kr****@portlite.com> wrote in message
news:50**************************@posting.google.c om...
I am trying to make addresses print on a report. I have two fields
for the street address, how do I make the second field not leave an
empty space on the report? I want the city, state, zip to print right
under the first address field if the second address field is null.

Thanks.

Nov 13 '05 #3

P: n/a
Karen wrote:
I am trying to make addresses print on a report. I have two fields
for the street address, how do I make the second field not leave an
empty space on the report? I want the city, state, zip to print right
under the first address field if the second address field is null.


Concatenate the street addresses w/ the City, State, Zip fields.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.