converted an mdb from access97 to 2007
some reports converted ok
others, the report footer section height is set to 22" and it can't be
changed
tried compact / repair & decompile, no change
deleted and reimported the report from access97, same problem
if I create a new report and copy / paste all the controls from the
old report, everything is fine
would could cause this ? is there a fix

On Aug 23, 4:29*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:
I tried saveAsText in access97 and loadFromText in access2007, same
problem
the height should only be .25", but when I enter that in the
properties, it resets automatically to 22"

Roger wrote:

This is a routine that will set the footer height to 1 inch (1440 twips
to an inch). Seems you've done what you can so it's very possible the
code will fail. Have you checked the margins of the report? Maybe
that's off. Since I put in a message box you could maybe try it for all
reports with a docname < "D" if you have some reports that fail that
start with A...C. Then rerun and see if any got set right.

Public Sub SetReportFooterHeight()

Dim dbs As Database
Dim doc As Document
Dim r As Report

Set dbs = CurrentDb

With dbs.Containers!Reports
For Each doc In .Documents
DoCmd.OpenReport doc.Name, acDesign
Set r = Reports(doc.Name)

'display to user the current height
MsgBox doc.name & " footer height is " & _
r.Section(acFooter).Height

'set the height to 1 inch
r.Section(acFooter).Height = 1440

Set r = Nothing
DoCmd.Close acReport, doc.Name, acSaveYes
Next doc
End With

MsgBox "Done"
End Sub

On Aug 23, 5:44*pm, Roger <lesperan... (AT) natpro (DOT) com> wrote:
closer examination of the text file, showed a top value of -30 for a
line within the section
in access97 it would be a 'divider' line right at the top of the
section
Begin Line
BorderWidth = 1
Left = 2318
Top = -30
Width = 7043
Name ="Line89"
End

changing it to Top = 30, allowed me to loadFromText and for the
section height to be set as required