Address Display

[cooke.christopher]

I have set up a little invoice database and things are going quite
well. My only issue is the display of the address. Each line of the
address is stored in a table separately (this is important for other
things I need to do with the data).

My problem is with how this is displayed on the invoice report. If I
give each text field its own line, then when there is no data in say
COName or recipAddress3 I get an ugly blank space. Same thing with the
city/state/zip line: if I leave enough space for the city name, i have
to push state and zip all the way off to the right, even if the city
field isn't full. Clearly there is a solution to this as this is a
common thing to display, but I have searched all over. Help is much
appreciated.

The fields are:

RecipName
COName
recipAddress1
recipAddress2
recipAddress3
City
State
Zip

And might display like:

John Doe
The John Doe Group
12 Doe Way


BigCity, NY 10007

 

[Jeff Boyce]

Take a look at the CanGrow and CanShrink properties of both the individual
controls and of the section overall. These will help you "close up" space
when there's a Null for that control's value.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[cooke.christopher]

This works well for the vertical displacement, but since city, state
and zip are all on one line, it doesn't seem to resolve that. I am
considering combining the three fields with VBA and having that fed to
the report.