Help with expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
That was perfect - but I was just getting ready to enter that - yeah right.

Thanks - George


Ken Snell said:
Try this:

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


--

Ken Snell
<MS ACCESS MVP>

George said:
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
Click to expand...
Click to expand...
 
Back
Top