Unbound Text and Image Question on Form

[TomP]

I have a field in my table called VI and it is formatted to yes/no. On this
form I added an unbound text control called LargeCheck and an image. This is
what I entered on the VI text box.

Private Sub VI_Click()
If Me.VI = 0 Then
Me.LargeCheck = ""
Me.Image294.Visible = False
Else
Me.LargeCheck = Chr(252)
Me.Image294.Visible = True
End If

Here is the problem:

When I click on the VI text (yes/no) field the unbound text and image will
respond correctly to the current record, but when I advance to the NEXT
record, the unbound text and image will not respond to the yes/not value on
that record unless I click on that field one more time. Is there a way I can
have the unbound text and image respond to whatever record is visible on the
form?

Thank you for your help,

Tom

 

[Dirk Goldgar]

I have a field in my table called VI and it is formatted to yes/no. On
this
form I added an unbound text control called LargeCheck and an image. This
is
what I entered on the VI text box.

Private Sub VI_Click()
If Me.VI = 0 Then
Me.LargeCheck = ""
Me.Image294.Visible = False
Else
Me.LargeCheck = Chr(252)
Me.Image294.Visible = True
End If

Here is the problem:

When I click on the VI text (yes/no) field the unbound text and image will
respond correctly to the current record, but when I advance to the NEXT
record, the unbound text and image will not respond to the yes/not value
on
that record unless I click on that field one more time. Is there a way I
can
have the unbound text and image respond to whatever record is visible on
the
form?

Use the form's Current event to execute the same set of statements.

 

[TomP]

Thank you so much!!! It works!!!

Tom

Use the form's Current event to execute the same set of statements.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)