make checkbox disappear

[Brian]

I have a continuous form where I can either enter a date or select a checkbox
if that field is NA. Since the underlying query pulls up all the dates
pertaining to that record, some of the fields will have dates and some will
have a corrosponding checkbox checked with no date in the date field.
Is there a way to make the checkbox disappear if there is a date in the
appropriate field.
in pseudocode:
if [dateMade] <> null then me.dateMadeCheckBox.visible = false

 

[louisjohnphillips]

I have a continuous form where I can either enter a date or select a checkbox
if that field is NA. Since the underlying query pulls up all the dates
pertaining to that record, some of the fields will have dates and some will
have a corrosponding checkbox checked with no date in the date field.
Is there a way to make the checkbox disappear if there is a date in the
appropriate field.
in pseudocode:
  if [dateMade] <> null then me.dateMadeCheckBox.visible = false

Have you considered:

If IsDate( DateMade ) then
Me.checkBoxField.visible = False
else
Me.checkBoxField.visible = True
end if

I would not try to use a "<>" not equal operator to identify nulls.

 

[Brian]

is there an event this should be tied to ?

I have a continuous form where I can either enter a date or select a checkbox
if that field is NA. Since the underlying query pulls up all the dates
pertaining to that record, some of the fields will have dates and some will
have a corrosponding checkbox checked with no date in the date field.
Is there a way to make the checkbox disappear if there is a date in the
appropriate field.
in pseudocode:
if [dateMade] <> null then me.dateMadeCheckBox.visible = false

Have you considered:

If IsDate( DateMade ) then
Me.checkBoxField.visible = False
else
Me.checkBoxField.visible = True
end if

I would not try to use a "<>" not equal operator to identify nulls.