Formating text in report 1

[dbero]

I am creating a report that starts out with
Name
Address1
Address2
City, State zipcode

If there is no value for address2, is it possible to shift the locatoin of city state zip up into the Address 2 location?

I am using an unbound data source.

thank you

 

[PHV]

Have a look at the Nz and/or IsNull functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dbero]

I am familiar with NZ, etc. What i need to do is to physicaly move the location of the label up 1/2 inch if address 2 is null.
there is a Top property on the label that i adjust in code, but it doesn't move it to a logical position.

 

[sxschech]

Look at the top position of the properties window for Address 2 and insert in (xxx). Look at the top position of the properites window for CityStateZip and insert in (yyy).
Put the code in the OnFormat or OnPrint event of the section where the textboxes are located.

If isnull(Me.Address2) Then
   Me.Address2.visible=false     
   Me.CityStateZip.Top= 1440*(xxx)
else
   Me.Address2.visible=true
   Me.CityStateZip.Top= 1440*(yyy)
endif