Try the following:

If name_of_Element = 1 //Yes or True
{
// do nothing
}
Else
{
Clear(name_of_element)
}

You will want to put ^ that code into the On Element Immediate Change event of the Checkbox. That will give the checkbox the choices of Yes or Undecided.

Modified my Notes on that subject. 

Quote:

This code does not work for unbound checkboxes.

(Cross-posted to Lantica Online Support Request)

olddog wrote on Jan 30^th, 2008 at 1:25am:

Much obliged!  Works like a champ.

Quote:


Ray, I'm having a little trouble understanding this. 

If I'm reading your code right, it seems to say "If the element is immediately cleared, turn it back on (yes)".  So either I'm reading it wrong or I'm just confused about states.  Or both.

I have the following code in my checkboxes OEIC, from a previous thread.

// Only allows a YES checkbox toggle (clears it if NO)

IF ThisElement <> 1
THEN
	{
	Clear(ThisElement)
	} 

What I'm trying to do is, if a user unchecks a box he makes it "No".  I'm assuming that the default value for all boxes, before any checking or unchecking, is "No".  What I want is for all my boxes to be "No" unless checked.

Help with understanding this would be appreciated.  I apologize if I've derailed the thread, as I know the original poster had a different objective.  Thanks!

Quote:

A little but I'm still not there.

Let's say I want to search records using = and /=.  Which two states am I searching for?  I'm pretty sure if I search using /= I will get 1/Yes/On.  Which state will = find?  Because that's the state I want to set it to if it's unchecked.

Thanks Ray.

Infinity wrote on Jan 31^st, 2008 at 6:16pm:



That is because you are trying to use the Blank as the Off in them. If the records that are not On were actually set to be Off then the Searching would work the way that you want it to. Off would retrieve Off, On would retrieve On and Unset would retrieve everything.

-Ray

There is a difference between NULL and Blank. Sesame does not allow NULL values but does allow you to have blank values.

Quote:


OK, so it looks like if I want to be able to search for the presence of a check or not, I want all my boxes to be either checked or unchecked, and eliminate all blank states.  If that's the case then I need some advice.

I currently use checkboxes in two of my databases/forms.  In one of them it's not really critical if they're checked, unchecked, or blank.  In the other it is.  So I'll concentrate on that.  If I succeed I'll transition the other form as well, just for grins and giggles.

What I need to do first is program the database so that when one opens a new, blank record, the default "blank" value of the box is set to 0/No/unchecked.  That's easy enough, I think.  The element is "Check_If_Driver", so some combination of If @Add or If @IsNew and If @IsBlank(Check_If_Driver)=yes should do it.

Then I'll need to Mass Update all my current records so the blank boxes become 0/No/Off.  This is where it gets tricky.  I suppose I'll have to program a retrieve because I can't access the element directly to check its state, I can only find either all checked or all ALL.

Then I'll need to program the element so that if it's not On, it's Off.  The programming you've detailed above should do that.

Is there anything I'm missing in the above plan?  Also, it it possible to eliminate the "blank" option from a retrieve spec?

Thanks for your help.

Quote:

Ah, of course.  I'm overthinking it.
Quote:

Cool, I've never done that.  Can an inverse search be saved in the spec manager?
Quote:

Yes, I probably will.  But I'm pretty sure it would throw my users for a loop, and I'd have difficulty explaining it.  Heck, I have difficulty understanding it.

Quote:

Shoot.  Saving it would be immensely useful.  Can it be programmed?

Quote:

I see what you mean.  Thank you.

Scott,

You need to come to the meeting Saturday. We can get you straightened out there.

[quote author=CapitalG link=1194898158/0#24 date=1202423302]When I set the default initial value to 0, I got the desired result of the inital value being off, but now it cycles through all three states.[/quote]
Yeah, I don't know why, but if you use "No" rather than "0" for the initial value, it should work.