Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IIF statement (A2000)

    I need to translate this text box After Update event into an IIF I can run on an update query.

    Me![tbxCorrectedString] = ProperManager(Me![tbxUncorrectedString], Me![optgrpConversion])

    The value returned by the option group in this case would be vbProperCase. Is this statement below even remotely close?

    =IIf(IsNull([field1]), [field1], ProperManger([field1], VBProperCase)

    E

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IIF statement (A2000)

    You cannot use the symbolic constant vbProperCase in an expression, you must replace it by its numeric value 3. If you're going to use it in an update query, you don't need = before the expression. This should work (if ProperManager is a public function - it is not a built-in function AFAIK)

    IIf(IsNull([field1]), Null, ProperManager([field1], 3)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •