Novice
Windows 10 
Office 365
Depending on whether a field in a table is blank or not, I want a check box on a form to be automatically checked (i.e. if the field is blank, the check box should be unchecked, and if the field is not blank, the check box should be checked).
Any idea how to do this?
VIP
Windows 10 Access 2010 32bit
This is data that does not need to be saved, just calculated. Have an expression in checkbox ControlSource.
=IIf(IsNull([somefield]), False, True)
However, what purpose does this checkbox serve?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
one rundomly selected check box toggles other check boxes in a group
Limit form to each dropdown option appearing once, enable check box if other check box is true
how to filter a date range and check another field is true with check box syntax err
Posting Permissions
Reply With Quote