Checkbox to show whether another field contains data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I would like to create a Checkbox on a form to indicate whether another
field in the table (not shown on the form) contains any data. Any help on the
Checkbox code would be appreciated.
Many thanks
 
Hi
I would like to create a Checkbox on a form to indicate whether another
field in the table (not shown on the form) contains any data. Any help on the
Checkbox code would be appreciated.
Many thanks
Click to expand...

Set its Control Source to

=Not IsNull([Fieldname])

The field must be included in the Query upon which the form is based,
but you don't need a control to display the field itself.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks very much.

John Vinson said:
Hi
I would like to create a Checkbox on a form to indicate whether another
field in the table (not shown on the form) contains any data. Any help on the
Checkbox code would be appreciated.
Many thanks
Click to expand...

Set its Control Source to

=Not IsNull([Fieldname])

The field must be included in the Query upon which the form is based,
but you don't need a control to display the field itself.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
The field must be included in the Query upon which the form is based,
but you don't need a control to display the field itself.
Click to expand...


Now I didn't know that! Excellent ... I have always put the field's
control on the form and then hidden it.

I love it when I find out something new :)
Cheers,
Brett
 
Back
Top