is Null then update problem

[fishqqq]

When [Text58] is null the message works perfectly but when [Text58] is
not null then [Text60] gets updated with the value of [Text58]. Is
there a way to have [Text60] remain empty if there is a value in
[Text58]?

Item [Text60]
Nz([Text58], "This record did NOT update correctly, please delete and
click the ADD NEXT SPLIT button from a previously updated record")

thanks
Steve

 

[John W. Vinson]

When [Text58] is null the message works perfectly but when [Text58] is
not null then [Text60] gets updated with the value of [Text58]. Is
there a way to have [Text60] remain empty if there is a value in
[Text58]?

Item [Text60]
Nz([Text58], "This record did NOT update correctly, please delete and
click the ADD NEXT SPLIT button from a previously updated record")

thanks
Steve

Sure. Change the NZ() expression to

IIF(IsNull([Text58]), "This record....", Null)

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[fishqqq]

When [Text58] is null the message works perfectly but when [Text58] is
not null then [Text60] gets updated with the value of [Text58]. Is
there a way to have [Text60] remain empty if there is a value in
[Text58]?

Item [Text60]
Nz([Text58], "This record did NOT update correctly, please delete and
click the ADD NEXT SPLIT button from a previously updated record")

thanks
Steve

Sure. Change the NZ() expression to

IIF(IsNull([Text58]), "This record....", Null)

--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Great, works perfectly - thanks