Prev: Vertical Bar error
Next: Disappearing custom groups
From: WuiChi on 29 Apr 2010 15:06
I have had issues with using vertical bars when typing code in to the
expression builder( the expression builder uses them as default). When I
replace them with commas to try and get it to work. Different error but
same implied message - I am not using my commas correctly. Here is code
someone else wrote as the control source I am trying to add a new text box
with another value. Vertical bar error when I cut and paste the code but
works in the text box it is in. Am I missing a reference to get the vertical
bars to work?/ Help

code
=IIf(([Request Decision]="Approved")|([CountOfRequest Decision])|"")
From: Jerry Whittle on 29 Apr 2010 16:28
=IIf([Request Decision]="Approved", [CountOfRequest Decision], Null)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"WuiChi" wrote:

> I have had issues with using vertical bars when typing code in to the
> expression builder( the expression builder uses them as default). When I
> replace them with commas to try and get it to work. Different error but
> same implied message - I am not using my commas correctly. Here is code
> someone else wrote as the control source I am trying to add a new text box
> with another value. Vertical bar error when I cut and paste the code but
> works in the text box it is in. Am I missing a reference to get the vertical
> bars to work?/ Help
>
> code
> =IIf(([Request Decision]="Approved")|([CountOfRequest Decision])|"")
 | 
Pages: 1
Prev: Vertical Bar error
Next: Disappearing custom groups