visable

[Chey]

I have 2 check boxes and 2command buttons.

This is the code I have now.
If [Late] = -1 Then
[Print Late Letter].Visible = True
Else
[Print Late Letter].Visible = False
End If

If [Grant Fund Questions Incorrect] = -1 Then
[Command147].Visible = True
Else
[Command147].Visible = False
End If

however when I check the box, the command button does not appear.
any suggestions?

 

[Douglas J Steele]

Try the following:

Me.[Print Late Letter].Visible = Nz(Me.[Late], False)
Me.[Command147].Visible = Nz(Me.[Grant Fund Questions Incorrect], False)

 

[Chey]

It still doesent work.
I have in on the under current shoud I put in after update?
I will try that.
I even double checked the spelling of the fields and command button.
Thanks

Try the following:

Me.[Print Late Letter].Visible = Nz(Me.[Late], False)
Me.[Command147].Visible = Nz(Me.[Grant Fund Questions Incorrect], False)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have 2 check boxes and 2command buttons.

This is the code I have now.
If [Late] = -1 Then
[Print Late Letter].Visible = True
Else
[Print Late Letter].Visible = False
End If

If [Grant Fund Questions Incorrect] = -1 Then
[Command147].Visible = True
Else
[Command147].Visible = False
End If

however when I check the box, the command button does not appear.
any suggestions?

 

[Douglas J. Steele]

If you expect the buttons to become visible when you check the check boxes,
then yes, it needs to be in the AfterUpdate event. You'd want to leave it in
the Current event as well, so that the buttons are (or aren't) visible when
you change records.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

It still doesent work.
I have in on the under current shoud I put in after update?
I will try that.
I even double checked the spelling of the fields and command button.
Thanks

Try the following:

Me.[Print Late Letter].Visible = Nz(Me.[Late], False)
Me.[Command147].Visible = Nz(Me.[Grant Fund Questions Incorrect], False)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have 2 check boxes and 2command buttons.

This is the code I have now.
If [Late] = -1 Then
[Print Late Letter].Visible = True
Else
[Print Late Letter].Visible = False
End If

If [Grant Fund Questions Incorrect] = -1 Then
[Command147].Visible = True
Else
[Command147].Visible = False
End If

however when I check the box, the command button does not appear.
any suggestions?