Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2005

Tip: Looking for answers? Try searching our database.

Labels with blank text box

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Baffee - 28 Oct 2005 15:47 GMT
I have  labels set up as follows:

Name
Contact
Address1
Address2
Address3
City State Zip

The query has clients from Department business and individual.   There is a
contact name for all clinets, but where the client is an individual, the name
and contact anre the same.  I don't want to show the contact where the
department is "Individual".  The data for the Contact  test box is
=IIf([DeptName]="Individual"," ",[Contact]).  

Now the problem is when the label prints, it is showing as:

Name

Address1
Address2
Address3
City State Zip

What do I have to do to get rid of the blanks?
Rick B - 28 Oct 2005 16:08 GMT
Try the "can shrink" property.  Or, set all the controls to one pixel high
and set the "can grow" property.

Signature

Rick B

>I have  labels set up as follows:
>
[quoted text clipped - 23 lines]
>
> What do I have to do to get rid of the blanks?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.