Text Box Control Source problems.

[neptune]

I built a form that pulls several fields from a query. In some
instances the [Contract#] field is empty and nothing displays in the
form text box. In this case I want a simple statement like "Item Not
Loaded". [Contract#] is a text data type.

I tried this and it didn't work:
IIf([Contract#] Is Null,"Item Not Loaded",[Contract#])
Someone suggested its not really Null, but blank so I should try this:
=IIf(CLng(Nz([Contract#],0)),[Contract#],"Not Loaded On AS400")
And
=IIf(CLng(Nz([Contract#],0)),"Not Loaded On AS400",[Contract#])
Also didn't work.
Any suggestions.

[fredg]

On 18 Feb 2004 14:12:00 -0800, neptune wrote:

I built a form that pulls several fields from a query. In some
instances the [Contract#] field is empty and nothing displays in the
form text box. In this case I want a simple statement like "Item Not
Loaded". [Contract#] is a text data type.

I tried this and it didn't work:
IIf([Contract#] Is Null,"Item Not Loaded",[Contract#])
Someone suggested its not really Null, but blank so I should try this:
=IIf(CLng(Nz([Contract#],0)),[Contract#],"Not Loaded On AS400")
And
=IIf(CLng(Nz([Contract#],0)),"Not Loaded On AS400",[Contract#])
Also didn't work.
Any suggestions.

Did you try:
=IIf(IsNull([Contract#]),"Item Not Loaded",[Contract#])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Mike Storr]

On 18 Feb 2004 14:12:00 -0800, neptune wrote:

I built a form that pulls several fields from a query. In some
instances the [Contract#] field is empty and nothing displays in the
form text box. In this case I want a simple statement like "Item Not
Loaded". [Contract#] is a text data type.

I tried this and it didn't work:
IIf([Contract#] Is Null,"Item Not Loaded",[Contract#])
Someone suggested its not really Null, but blank so I should try this:
=IIf(CLng(Nz([Contract#],0)),[Contract#],"Not Loaded On AS400")
And
=IIf(CLng(Nz([Contract#],0)),"Not Loaded On AS400",[Contract#])
Also didn't work.
Any suggestions.

It may think you are trying to set it to the field named "Not Loaded On
AS400" - which dosen't exist. I think it may only be possible to do this
with an unbound control that refers not to the field names, but the form
control name that holds Contract#. In effect a calculated control.

--
Mike Storr
www.veraccess.com

[Hegamyer]

Did you try

[Contract#]=""

The double quotes indicating that it's a zero length, rather than null
value?

"neptune" <bs**********@hotmail.com> wrote in message
news:c5**************************@posting.google.c om...

I built a form that pulls several fields from a query. In some
instances the [Contract#] field is empty and nothing displays in the
form text box. In this case I want a simple statement like "Item Not
Loaded". [Contract#] is a text data type.

I tried this and it didn't work:
IIf([Contract#] Is Null,"Item Not Loaded",[Contract#])
Someone suggested its not really Null, but blank so I should try this:
=IIf(CLng(Nz([Contract#],0)),[Contract#],"Not Loaded On AS400")
And
=IIf(CLng(Nz([Contract#],0)),"Not Loaded On AS400",[Contract#])
Also didn't work.
Any suggestions.

[Hegamyer]

Have you tried using double quotes instead of null? Like saying
[Contract#]=""?

"neptune" <bs**********@hotmail.com> wrote in message
news:c5**************************@posting.google.c om...

I built a form that pulls several fields from a query. In some
instances the [Contract#] field is empty and nothing displays in the
form text box. In this case I want a simple statement like "Item Not
Loaded". [Contract#] is a text data type.

I tried this and it didn't work:
IIf([Contract#] Is Null,"Item Not Loaded",[Contract#])
Someone suggested its not really Null, but blank so I should try this:
=IIf(CLng(Nz([Contract#],0)),[Contract#],"Not Loaded On AS400")
And
=IIf(CLng(Nz([Contract#],0)),"Not Loaded On AS400",[Contract#])
Also didn't work.
Any suggestions.