Checkbox to show whether another field contains data

D

DaveL

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
 
J

John Vinson

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
 
D

DaveL

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...
 
B

Brett Collings [429338]

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
 
Top