Shrink Field

[Karen]

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.

[PC Datasheet]

Re: Shrink Field

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
resource@pcdata sheet.com

https://www.pcdatasheet.com

"Karen" <krmoss@portlit e.com> wrote in message
news:5051d139.0 409101228.746c1 870@posting.goo gle.com...[color=blue]
> 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.[/color]

[Squirrel]

Re: Shrink Field

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" <krmoss@portlit e.com> wrote in message
news:5051d139.0 409101228.746c1 870@posting.goo gle.com...[color=blue]
> 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.[/color]

[MGFoster]

Re: Shrink Field

Karen wrote:
[color=blue]
> 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.[/color]

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

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