It won't stop printing blank fields! help!

Thanks to everyone for help on DSN-less connections.  I still haven't 
gotten it to work but I am a lot further than I was!

Now, I need your help again.

I'm using Dreamweaver UltraDev to set up my databases.  The problem is, I 
can't figure out how to keep an empty field in a record from printing a 
blank space.  For example, I've got a database set up to display these 
fields in a record:

Company
Contact
Title
Address1
Address 2
City
State
Zip

Now, if the Address2 field is blank, the record shows as

Company
Contact
Title
Address1

City
State
Zip

How do I get it to just not print that space if the record is empty!  I am 
sure this is incredibly basic but I have tried everything.  Thanks for your 
help (in advance)

Danny

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA