Tick box for a date field

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
 
G

glue

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top