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

  • Question

  • 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

  • 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