IIF Statement Help
in [Form]
|
Prev: Date format in a combo box
Next: Loopup Box
From: cathyt on 16 Apr 2010 08:00 Dirk, The values are as follows: SIGNWORK: 1. (Value List) "None";"Install";"Replace";"Repair";"Remove";"Relocate";"Relocate & Replace";"Relocate & Repair" 2. one 3. one 4. blank FACETYPE 1. (Value List) “High Intensity”;”Diam. Grade” 2. one 3. one 4. blank Thanks, Cathy "Dirk Goldgar" wrote: > "cathyt" <cathyt(a)discussions.microsoft.com> wrote in message > news:5661C0D0-6BAE-47FC-8AB4-19FBE93B303C(a)microsoft.com... > > Peter and Dirk, > > Thanks for your replies. I've tried both suggestions and for each get an > > error message: Expressions contains Invalid syntax; may have entered an > > operand without an operator. > > It's always possible I made a mistake in my expression, but I'm not seeing > it. You mentioned that [SIGNWORK] and [FACETYPE] are combo boxes. What are > the values of these properties for each: > > Row Source > Bound Column > Column Count > Column Widths > > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) >
From: Dirk Goldgar on 16 Apr 2010 10:18 "cathyt" <cathyt(a)discussions.microsoft.com> wrote in message news:958650D6-FF06-4BB4-836A-26814887CCB9(a)microsoft.com... > Dirk, > The values are as follows: > SIGNWORK: > 1. (Value List) > "None";"Install";"Replace";"Repair";"Remove";"Relocate";"Relocate & > Replace";"Relocate & Repair" > 2. one > 3. one > 4. blank > > FACETYPE > 1. (Value List) “High Intensity”;”Diam. Grade” > 2. one > 3. one > 4. blank Somehow we've got "smart quotes" in some of those values, and in the IIf() expression -- things that look like simple double-quotes when view as plain text, but aren't. Edit your rowsource lists and replace all quotes with a freshly typed " character, and do the same with the ControlSource expression. When I do that in a test form, it all works fine. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup)
From: cathyt on 19 Apr 2010 09:10
Dirk, That was it exactly. It works exactly as I want it to now. Thanks for your time and expertise! Cathy "Dirk Goldgar" wrote: > "cathyt" <cathyt(a)discussions.microsoft.com> wrote in message > news:958650D6-FF06-4BB4-836A-26814887CCB9(a)microsoft.com... > > Dirk, > > The values are as follows: > > SIGNWORK: > > 1. (Value List) > > "None";"Install";"Replace";"Repair";"Remove";"Relocate";"Relocate & > > Replace";"Relocate & Repair" > > 2. one > > 3. one > > 4. blank > > > > FACETYPE > > 1. (Value List) “High Intensity”;”Diam. Grade” > > 2. one > > 3. one > > 4. blank > > > Somehow we've got "smart quotes" in some of those values, and in the IIf() > expression -- things that look like simple double-quotes when view as plain > text, but aren't. Edit your rowsource lists and replace all quotes with a > freshly typed " character, and do the same with the ControlSource > expression. When I do that in a test form, it all works fine. > > -- > Dirk Goldgar, MS Access MVP > Access tips: www.datagnostics.com/tips.html > > (please reply to the newsgroup) > |