I have a report that I make formatting changes when it opens based on the underlying table. However when I preview it the formatting is OK, when I print the form directly the format is not correct.
Here is the code behind the report
Private Sub Report_Activate()
'1 inch = 1440 twips
If Me.LensMaterial = "Poly" Then Me.MHMaterial.Move Left:=7260, Top:=8520
If Me.RxType = "Single Vision" Then
Me.MHFT28.Visible = False
Me.MHType.Move Left:=660, Top:=9180
Me.MHFT28.Visible = True
From another form here is the code that calls up the report:
DoCmd.OpenReport "rMassHealth", acViewPreview, , "(((tMain.TrayNo) Like [forms]![FMain]![TrayNo]))"
Any idea why this isn't working with printing directly?