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 / May 2008

Tip: Looking for answers? Try searching our database.

Blank Lines

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
OldManEd - 26 May 2008 21:33 GMT
I have a report that includes a cell phone field as a separate line in the
report. It leaves a blank line when the cellphone field is empty. Is there a
way to skip this and avoid a blank line?

OMEd
Evi - 26 May 2008 23:32 GMT
Ensure that the Cellphone textbox has the Can Grow/Can Shrink Properties set
to yes. Do the same for the section containing this control (unless you are
making a label report)
Things that could stop this happening is an unattached label on the same row
as the text box (to attach the label, if it no longer moves when you move
the textbox, cut it, select the text box and paste it).

If you can't use CanGrow/Can shrink then you can use the On Format Event of
the Section to make the control invisible

eg

If IsNull(Me.CellPhone) Then
Me.CellPhone.Visible = False
Else
Me.CellPhone.Visible=True
End If

Evi

> I have a report that includes a cell phone field as a separate line in the
> report. It leaves a blank line when the cellphone field is empty. Is there a
> way to skip this and avoid a blank line?
>
> OMEd
 
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.