<div>
hi InvisibleMan,<br />
<br />
try this:<br />
<br />
=IIf(IsNull([rate]);0;[rat<wbr />e])<br />
<br />
cheers<br />
Ricky
</div>


hi InvisibleMan,

try this:

=IIf(IsNull([rate]);0;[rate])

cheers
Ricky

<div>
or <br />
<br />
=IIf(IsNull([rate]) Or Trim([rate] = &quot;&quot;);0;[rate])<br />
<br />
-cf
</div>


or

=IIf(IsNull([rate]) Or Trim([rate] = "");0;[rate])

-cf

<div>
PsychoDazey, Just put the control source property:<br />
=Nz(Me.[Rate],0) &nbsp;<br />
:)<br />

</div>


PsychoDazey, Just put the control source property:
=Nz(Me.[Rate],0)  
:)


<div>
That is what I dis hsanr (refer to my comment above yours)?!?!? &nbsp;Did you mean to refer that comment to InvisibleMan? 
</div>


That is what I dis hsanr (refer to my comment above yours)?!?!?  Did you mean to refer that comment to InvisibleMan?

<div>
PsychoDazey ,<br />
I was referring to your comment, which is now accepted answer, to remove: Me![Rate].Control Source before the equal sign. :)
</div>


PsychoDazey ,
I was referring to your comment, which is now accepted answer, to remove: Me![Rate].Control Source before the equal sign. :)

<div>
<div class="content wysiwyg-content">
I have an ADP database that when a value is coming up blank the IIF statement does not work correctly. &nbsp;For example:<br />
<br />
Control Source<br />
=IIF([Rate]=&quot;&quot;,0[Rate])<br />
&nbsp;The textbox is still blank. &nbsp;Any idea?
</div>
</div>


I have an ADP database that when a value is coming up blank the IIF statement does not work correctly.  For example:

Control Source
=IIF([Rate]="",0[Rate])
 The textbox is still blank.  Any idea?

IIF BLANK TEXT BOX ISSUE

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.