can grow can shrink properties ????

A

ally

Hi


I am trying to make a report with my field


=VraiFaux(EstNull([Titre]);"";[Titre] & Car(13) & Car(10)) &
VraiFaux(EstNull([Prénom]);[NomFamille] & Car(13) & Car(10);[Prénom] &
" " & [NomFamille] & Car(13) & Car(10)) & VraiFaux(EstNull([Société/
Entreprise]);"";[Société/Entreprise] & Car(13) & Car(10)) &
VraiFaux(EstNull([ContactPersonne]);"";[ContactPersonne] & Car(13) &
Car(10)) & [Adresse] & Car(13) & Car(10) & [Expr2]

so that the end of the adress is always at 2 cm from the edge (bottom
and left) of the paper
since some of my fields are empty , the address moves accordingly.

is there a way of making a combination of the content to make the
field appear always at the same distance from the edge ????

thank you for your help
ally
 
M

M Skabialka

Eliminating unwanted blank lines in labels and reports:
http://office.microsoft.com/en-us/access/HA011494721033.aspx

This will get rid of those blank lines.
Left justify the field with a 2cm position.
Maybe if you use a footer it will work to keep it at the same distance from
the bottom?

Mich

Hi


I am trying to make a report with my field


=VraiFaux(EstNull([Titre]);"";[Titre] & Car(13) & Car(10)) &
VraiFaux(EstNull([Prénom]);[NomFamille] & Car(13) & Car(10);[Prénom] &
" " & [NomFamille] & Car(13) & Car(10)) & VraiFaux(EstNull([Société/
Entreprise]);"";[Société/Entreprise] & Car(13) & Car(10)) &
VraiFaux(EstNull([ContactPersonne]);"";[ContactPersonne] & Car(13) &
Car(10)) & [Adresse] & Car(13) & Car(10) & [Expr2]

so that the end of the adress is always at 2 cm from the edge (bottom
and left) of the paper
since some of my fields are empty , the address moves accordingly.

is there a way of making a combination of the content to make the
field appear always at the same distance from the edge ????

thank you for your help
ally
 
Top