adding text to a dlookup return value

[smaier]

Hello, all!



What I'm trying to do is add some text to the return value of a dlookup depending on if the adjacent textbox has a value or not. This is through the Control Source of the textbox's properties.

As an example:
If Text1's value = 0.255 (this is a return of its current dlookup without trying to add anything)
and Text2's value = 0.005
Leave Text1's value as 0.255

If Text1's value = 0.255
and Text2 is empty
Make Text1's rendered value will read (0.255)

I tried something like:

=IIf([Forms]![FormInQuestion]![Text2]=Null, "(" & (DLookUp("[TableField]","PartList","PN_ID = " & [Forms]![FormInQuestion]![TextBoxWithValueToMatch])) & ")", DLookUp("[TableField]","PartList","PN_ID = " & [Forms]![FormInQuestion]![TextBoxWithValueToMatch]))

The part in bold is was my attempt at achieving this but it's not working as intended. I'm just getting/seeing the 0.255. Does this seem like it should work and my problem is elsewhere or is my syntax wrong?

I do appreciate the help!

[CJ_London]

nothing = null, not even null

try

=iif(isnull(([Forms]![FormInQuestion]![Text2]),......

also don't think you need all those brackets for the true part of the iif function

DLookUp("[TableField]","PartList","PN_ID = " & [Forms]![FormInQuestion]![TextBoxWithValueToMatch])

[smaier]

nothing = null, not even null

try

=iif(isnull(([Forms]![FormInQuestion]![Text2]),......

That was exactly it. Thank you so much.

You were also right in there were unnecessary parenthesis in the true part if the iif. I'd been poking it with a stick for too long and was trying whatever I could think of :P

Cheers, friend!



Edit: Couldn't find a way to change the thread title to "Solved".

[CJ_London]

Couldn't find a way to change the thread title to "Solved".

in the green bar at the top of the thread, click on 'thread tools'. The option is in the dropdown