By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,345 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

Me.Top is negative, how can i correct it?

P: 14
um hi, i am using MS Access 2003. i am creating a report with an embebed sub report.

It and the detail section that is in have the can Grow property. ok now in this code

Expand|Select|Wrap|Line Numbers
  1. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  2.  
  3.     Dim strImagePath As String
  4.     Dim strImagePath2 As String
  5.  
  6.     On Error Resume Next
  7.      If (Me.Extra= -1) Then
  8.         Me.ImageFrame.Visible = True
  9.         Me.Pieces.Visible = True
  10.         Me.Line112.Visible = True
  11.         Me.Line133.Visible = True
  12.         Me.Commentary.Visible = True
  13.         Me.Desc_box.Visible = True
  14.         Me.TDesc.Visible = True
  15.         Me.TxtDesc.Visible = True
  16.         Me.ImageFrame2.Visible = False
  17.  
  18.         strImagePath = Me.Imagen
  19.         Me.ImageFrame.Picture = strImagePath
  20.         strImagePath2 = (none)
  21.         Me.ImageFrame2.Picture = strImagePath2
  22.  
  23.      Else
  24.         Me.Pieces.Visible = False
  25.         Me.Line112.Visible = False
  26.         Me.Line133.Visible = False
  27.         Me.Commentary.Visible = False
  28.         Me.Desc_box.Visible = False
  29.         Me.TDesc.Visible = False
  30.         Me.TxtDesc.Visible = False
  31.         Me.ImageFrame2.Visible = True
  32.  
  33.         strImagePath = (none)
  34.         Me.ImageFrame.Picture = strImagePath
  35.         strImagePath2 = Extra
  36.         Me.ImageFrame2.Picture = strImagePath2
  37.      End If
  38.  
  39.      If Me.Top < 0 Then
  40.         MsgBox (Me.Top)
  41.      End If
  42.  
  43. End Sub
  44.  
The MsgBox(Me.Top) is giving Me -8543 when the subreport grows.

And everything else is not showing Imageframe1, tdesc, txtdesc etc.

is there any idea of wha i can do to make them show?
Aug 3 '10 #1
Share this Question
Share on Google+
1 Reply


P: 14
solved by creating a new column with the page number... not clasy but working

basically inside de sub form made it so that there can not be mote than N columns and making on the value on new column to number page and created a Child master and sorting and grupoing through that value
Aug 13 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.