error in IIf

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

hi,

i have the following:

=IIf([T2104]=#1/1/2009#,"N","Y")

i made sure to check the format in the table, and it is date/time format.
not sure what i am doing wrong.

thanks in advance,
geebee
 
Where is this being used and what does T2101 represent?
This should be correct in a query but Me!T2101 might be needed in a form.
 
It looks as though you're attempting to use that as the control source for a
text box. Is that correct?

What problem are you having? Are you getting an error? If so, what's the
error message? If you're not getting an error, what are you getting, and
what did you expect to get instead?
 
getting an "invalid control property: control source" when i click on the
green triangle in the field. this is the controlsource, and i do not have
another field named T2104 in the form. I am simply using this table column
within the formula in this error field.


Douglas J. Steele said:
It looks as though you're attempting to use that as the control source for a
text box. Is that correct?

What problem are you having? Are you getting an error? If so, what's the
error message? If you're not getting an error, what are you getting, and
what did you expect to get instead?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


geebee said:
hi,

i have the following:

=IIf([T2104]=#1/1/2009#,"N","Y")

i made sure to check the format in the table, and it is date/time format.
not sure what i am doing wrong.

thanks in advance,
geebee
Click to expand...
Click to expand...
 
And the recordsource of the form is a table or a query that includes T2104
as a field?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


geebee said:
getting an "invalid control property: control source" when i click on the
green triangle in the field. this is the controlsource, and i do not have
another field named T2104 in the form. I am simply using this table
column
within the formula in this error field.


Douglas J. Steele said:
It looks as though you're attempting to use that as the control source
for a
text box. Is that correct?

What problem are you having? Are you getting an error? If so, what's the
error message? If you're not getting an error, what are you getting, and
what did you expect to get instead?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


geebee said:
hi,

i have the following:

=IIf([T2104]=#1/1/2009#,"N","Y")

i made sure to check the format in the table, and it is date/time
format.
not sure what i am doing wrong.

thanks in advance,
geebee
Click to expand...
Click to expand...
Click to expand...
 
yes. i checked my subform and T2104 is listed in the recordsource's query,
which is in turn based on a table.




Douglas J. Steele said:
And the recordsource of the form is a table or a query that includes T2104
as a field?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


geebee said:
getting an "invalid control property: control source" when i click on the
green triangle in the field. this is the controlsource, and i do not have
another field named T2104 in the form. I am simply using this table
column
within the formula in this error field.


Douglas J. Steele said:
It looks as though you're attempting to use that as the control source
for a
text box. Is that correct?

What problem are you having? Are you getting an error? If so, what's the
error message? If you're not getting an error, what are you getting, and
what did you expect to get instead?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


hi,

i have the following:

=IIf([T2104]=#1/1/2009#,"N","Y")

i made sure to check the format in the table, and it is date/time
format.
not sure what i am doing wrong.

thanks in advance,
geebee
Click to expand...
Click to expand...
Click to expand...
 
You mention "subform". Is this code running in the module associated with
the subform, or with some other form?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


geebee said:
yes. i checked my subform and T2104 is listed in the recordsource's
query,
which is in turn based on a table.


Douglas J. Steele said:
And the recordsource of the form is a table or a query that includes
T2104
as a field?

geebee said:
getting an "invalid control property: control source" when i click on
the
green triangle in the field. this is the controlsource, and i do not
have
another field named T2104 in the form. I am simply using this table
column
within the formula in this error field.


:

It looks as though you're attempting to use that as the control source
for a
text box. Is that correct?

What problem are you having? Are you getting an error? If so, what's
the
error message? If you're not getting an error, what are you getting,
and
what did you expect to get instead?


hi,

i have the following:

=IIf([T2104]=#1/1/2009#,"N","Y")

i made sure to check the format in the table, and it is date/time
format.
not sure what i am doing wrong.

thanks in advance,
geebee
Click to expand...
Click to expand...
Click to expand...
 
Back
Top