RE: Using Iif and De together...

2006-12-07 Thread Bobby Hartsfield
Couldn’t you just use: If it already exists, its value will be in form.listing_openhouse If it DOES not exist, it will be created and the value "N" will be stored in it. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Andy Matthews [mailt

RE: Using Iif and De together...

2006-12-07 Thread Andy Matthews
I think that's what I was missing guys. The extra set of quotes on the final argument. Thanks Michael and jedihomer -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday, December 07, 2006 9:48 AM To: CF-Talk Subject: Re: Using Iif and De together...

Re: Using Iif and De together...

2006-12-07 Thread Michael Dinowitz
Two points. The first is that any variable or function used in the last 2 arguments will be evaluated both before and after the tag runs and DE is used only to quote a variable/function rather than forcing the programmer to do it themselves. That being said, the problem is probably in your secon

Re: Using Iif and De together...

2006-12-07 Thread JediHomer
IIf(StructKeyExists(FORM, "listing_openhouse"), 'Trim(FORM.listing_openhouse)', '"N"') *should* do it :) On 07/12/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > I KNOW that I've used this method successfully before, but for some reason > it's not working correctly now. > > I've got a radio butto