hide adn move adresses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all
i have a report based on addresses of the people so it shows:

Name
Address
Zip Code code + city
Country

what i want is in case of a person don't have the Zip code and city .. put
the country below of the address... and delete the blank line of the zip code
and the city

how could i do that?

thanks in advance
 
Tiago

Look into the CanGrow and CanShrink properties (if you are using separate
controls for each of these "lines".

If you are assembling a complete block of text (with carriage returns) to
fit into a single control, you'll need to include logic that leaves out the
carriage return/line feed for the "empty" line.
 
Chr(10) + Chr(13) gives you a carriage return and a line feed (and I never
use them separately, so I don't remember which is which!).

I'd probably recommend using separate fields, however, and the CanGrow,
CanShrink properties...

Jeff Boyce
<Access MVP>
 
Back
Top