Tick box for a date field

  • Thread starter Thread starter 3.14
  • Start date Start date
3

3.14

Can you make a date field be displayed as a tick box?

For example,

I have a date field. It has a date in it, therefore, it has a tick i
the tick box on the form. If the date field was empty there would be n
tick.

Can this be done?

Thanks in advance
 
maybe in the form_current event

if IsNull(me!DateField) then me.tickbox=false else me.tickbox=true
or more concisely
me.tickbox=not isnull(me!datefield)

you might instead use the iif function in the control source for th
tickbox i.e. =iif(isnull(DateField),false,true)

Aaro
 
Back
Top