Help with expression

[Guest]

I have a text box that fills in based on what info you click on in a List
Box. The thing is I don't want it to fill in unless the field next to it has
data entered.

List box is "List136
Field that gets List Box data is "Text52"
Field next to it is "Text46"

In the Text52 source box I entered =list136 if text46 is not null

Of course that didn't work but should look something like that.

Thanks - George

 

[Ken Snell [MVP]]

Try this:

=IIf(Len([text46] & "")=0, Null, [list136])

 

[Guest]

That was perfect - but I was just getting ready to enter that - yeah right.

Thanks - George

Try this:

=IIf(Len([text46] & "")=0, Null, [list136])


--

Ken Snell
<MS ACCESS MVP>

I have a text box that fills in based on what info you click on in a List
Box. The thing is I don't want it to fill in unless the field next to it
has
data entered.

List box is "List136
Field that gets List Box data is "Text52"
Field next to it is "Text46"

In the Text52 source box I entered =list136 if text46 is not null

Of course that didn't work but should look something like that.

Thanks - George