Hide Checkbox if textbox is null

[Marks]

Hi There,
Need some help, on Access Reports if the text box is null is there a code which will hide the checkbox?

[Carl Witte]

Well the easist way is probably to put

if isnull(mytestfield) then
mychkbox.visible = false
else 
mychkbox.visible = true
end if
 

This code could go on the "oncurrent" for the form or preferrably the "afterupdate" for the text box. The reason one is preferable to the other is the oncurrent runs ALOT and the other only happens when a user modifies and leaves the text box.

[Marks]

Thanks Carl,
However wouldn't this still show still as a Report?

Cheers

Well the easist way is probably to put

if isnull(mytestfield) then
mychkbox.visible = false
else 
mychkbox.visible = true
end if
 

This code could go on the "oncurrent" for the form or preferrably the "afterupdate" for the text box. The reason one is preferable to the other is the oncurrent runs ALOT and the other only happens when a user modifies and leaves the text box.

[missinglinq]

Carl's code is correct, but he didn't pay enough attention to the question! To do this in a Report it needs to go in the Detail_Format event of the Report.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(mytestfield) Then
  mychkbox.Visible = False
Else
  mychkbox.Visible = True
End If
End Sub
 

Linq ;0)>

[MMcCarthy]

Also using the can shrink property on the control will reduce the amount of white space used in the report.

[Carl Witte]

Carl's code is correct, but he didn't pay enough attention to the question! To do this in a Report it needs to go in the Detail_Format event of the Report.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(mytestfield) Then
  mychkbox.Visible = False
Else
  mychkbox.Visible = True
End If
End Sub
 

Linq ;0)>

DARNIT. I always seem to be doing that. Sorry.

[missinglinq]

Detail! Detail!

;0)>