nz function

[samotek]

Will you help me build the proper code including cases when there is a Null value.I have the following code :
If Me![Stueck] <> Nz(Me!In - Me!Out, 0) Then
Me!Stueck.ForeColor = 255

However i do not want to show this color when there is no value in the Out text box.
For example
in out stueck
15 15
i cannot get this solution.The above code gives me a red color when i have In = 15, stueck = 15 and nothng in out.

 

[SeeThru]

try nesting IFs

if isnull(out) then
Me!Stueck.ForeColor = 0
else
If Me![Stueck] <> Nz(Me!In - Me!Out, 0)
Me!Stueck.ForeColor = 255
else
Me!Stueck.ForeColor = 0
end if
end if


SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk