IIF statement (A2000)

Topic

New Reply

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

Reply | Quote

Replies

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)

Reply | Quote

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)

Reply | Quote