Report Width Stuck

[Blake Rice]

Hi, I have a report that is stuck at 13.675" and it will NOT shrink. It can grow but it will not get any narrower than that. Here is what I have tried, I have looked for any objects that are blocking my report from getting narrow. I have made every section taller to look for any line stragglers, nothing. I have made my report 22" done a ctr-A and deleted EVERY control on my report, nothing. I have selected from 14" to 0" on the top ruler to get all objects in the vertical line, nothing. I have gone into the page setup and tried to adjust the width through that, nothing. I have tried to adjust it in the properties, nothing. I have tried to adjust it through VBA, nothing.

WTF is going on? I am out of ideas and I cant find any reason that this report couldn't become narrower. Has anyone else had this problem?

Blake

[Blake Rice]

Well I found the rogue line, for anyone interested I used Allen Browne's code

Function FindRogue()
Dim rpt As Report
Dim ctl As Control
Dim strDoc As String
 
strDoc = "04 - Backlog Report - Valley"
DoCmd.OpenReport (strDoc), acViewDesign
Set rpt = Reports(strDoc)
 
For Each ctl In rpt.Controls
If ctl.Width > 6.5 * 1440 Then
Debug.Print ctl.Name, ctl.Width
End If
Next
 
Set rpt = Nothing
DoCmd.Close acReport, strDoc
End Function
 

Very helpful