error in IIf

[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

 

[Mike Painter]

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.

 

[Douglas J. Steele]

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?

 

[geebee]

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?

--
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

 

[Douglas J. Steele]

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!)

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?

--
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

 

[geebee]

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

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!)

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?

--
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

 

[Douglas J. Steele]

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!)

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

And the recordsource of the form is a table or a query that includes
T2104
as a field?

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