Is this possible with a textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box that is currently set up so that it has a control source of
a query and takes the value of a cell in a table.
What I would like to happen is that if the qry does not find a value then
the text box is assigned the value -1, if it does find the value however I
would like it to take on that value.
Thanks
-Steve
 
I presume you mean a control source of a field in a query?

You can use IIf in the query so in place of MyField in the Field row put
something like:
Expr1: IIf(IsNull([MyField]),-1,[MyField]) and make Expr1 the control source
of your text box

Look up IIF in help to see how it works

HTH
 
Thanks Jon
I found some information on the Nz Function and ended up using that.
Thanks again.

Jon Lewis said:
I presume you mean a control source of a field in a query?

You can use IIf in the query so in place of MyField in the Field row put
something like:
Expr1: IIf(IsNull([MyField]),-1,[MyField]) and make Expr1 the control source
of your text box

Look up IIF in help to see how it works

HTH


steveatdb said:
I have a text box that is currently set up so that it has a control source
of
a query and takes the value of a cell in a table.
What I would like to happen is that if the qry does not find a value then
the text box is assigned the value -1, if it does find the value however I
would like it to take on that value.
Thanks
-Steve
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List Box that populates Values and provides a total in a Report 1
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
Subquery Correllated In Select Clause - Is this possible? 3
Bind the whole method with a text box 2
How to read a specific column in a multi-column combo box? 2
Parameter Value error in a Subform 0
store a value of a text box that calculates data into a data sourc 2
many textbox selections 1

Back
Top