locked
Need to update image when report prints or goes to print preview RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am working on a singular report, whose data is determined by the current record of a form.

    On the report, I am trying to update the visible property of an image, based on the value of a field in the current record.

    I don't get the "We are here" - nor am I getting any images appearing. 

    The code I have in the OnCurrent event of the report is:

    MsgBox ("We are here")
   Me.Star1.Visible = False
   Me.Star2.Visible = False
   Me.Star3.Visible = False
   Me.Star4.Visible = False
   Me.Star5.Visible = False

Select Case Me.rcp_Rating.Value
   Case 0
      Me.Star1.Visible = False
      Me.Star2.Visible = False
      Me.Star3.Visible = False
      Me.Star4.Visible = False
      Me.Star5.Visible = False
   Case 1
      Me.Star1.Visible = True
      Me.Star2.Visible = False
      Me.Star3.Visible = False
      Me.Star4.Visible = False
      Me.Star5.Visible = False
   Case 2
      Me.Star1.Visible = True
      Me.Star2.Visible = True
      Me.Star3.Visible = False
      Me.Star4.Visible = False
      Me.Star5.Visible = False
   Case 3
      ...
   Case 4
      ...
   Case 5
      ...
End Select

    Tuesday, January 3, 2017 9:06 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Darcy,

    If you're not getting the MsgBox, then the event is probably not firing. Try using the Format event of the Details section and then view the report in Print Preview mode.

    Hope it helps...

    Tuesday, January 3, 2017 9:58 PM