Is it possible to create an if statement that when checkbox has been checked, 3 data input will be disable which is an amount. I hope you can help me with this.
Thanks in advance.
Is it possible to create an if statement that when checkbox has been checked, 3 data input will be disable which is an amount. I hope you can help me with this.
Thanks in advance.
Can use Conditional Formatting to disable textboxes or comboboxes.
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.
Can have conditional expression that displays 0 when box is checked.
=IIf([checkbox], 0, other calc here)
But if these textboxes already have calculations then why need to disable? Cannot input value to a textbox with an expression or if bound to query calculated field.
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.