Check Box Situation

[Chad Allen]

Here is my situation I have a database on Access 97 in
which there is a check box on my form. I also have a memo
field on my form. Now, what I want to do is when data is
entered in the memo field then it will automatically check
the check box. And if the memo field is changed and all
data is deleted from it (null) then the check box will
uncheck.

I was trying to use the SetValue function in a macro to
set the value of the checkbox field [e] to 0 (=unchecked)
or -1 (=checked) depending on if the memo field [except]
had data or was null. I haven't had any luck. Any
suggestions?

 

[Steve Schapel]

Chad,

Your idea of using the SetValue macro action should work ok. You
didn't mention how you tried to use it, but I would imagine that the
AfterUpdate event of the text field would be the applicable event.
Then, in your macro, you need to put something like this in the
Condition column for each of the two SetValue actions...
[except] Is Null
[except] Is Not Null

- Steve Schapel, Microsoft Access MVP