Can a textbox Control Source reference specific fields ?

[Steve G.]

Is it possible for a textbox Control Source to reference a specific field
based on a true/false condition? If so, what is the expression?

Simplified… if the value of a temporary value is true, I need the Control
Source to reference field A, otherwise, I need the Control Source to
reference field B.
Any help would be appreciated!
Thanks…

 

[Jack Cannon]

Steve,

Try This:
=IIf(Boolean Expression,[FieldA],[FieldB])

Jack Cannon

 

[Jack Cannon]

Steve,

I should add that I have never got this to work in AC2000 or earlier.
I have only got it to work in AC2002 or later.

Jack Cannon

Steve,

Try This:
=IIf(Boolean Expression,[FieldA],[FieldB])

Jack Cannon

Is it possible for a textbox Control Source to reference a specific field
based on a true/false condition? If so, what is the expression?

Simplified… if the value of a temporary value is true, I need the Control
Source to reference field A, otherwise, I need the Control Source to
reference field B.
Any help would be appreciated!
Thanks…

 

[Steve G.]

Jack,
I'm using AC2007 and it worked fine.
Thanks for your quick response!
Steve

Steve,

I should add that I have never got this to work in AC2000 or earlier.
I have only got it to work in AC2002 or later.

Jack Cannon

Steve,

Try This:
=IIf(Boolean Expression,[FieldA],[FieldB])

Jack Cannon

Is it possible for a textbox Control Source to reference a specific field
based on a true/false condition? If so, what is the expression?

Simplified… if the value of a temporary value is true, I need the Control
Source to reference field A, otherwise, I need the Control Source to
reference field B.
Any help would be appreciated!
Thanks…