IIF Formula

  • Thread starter Thread starter TIML
  • Start date Start date
T

TIML

I have a simple iif formula inside an unbound textbox. I keep getting an
#Error instead of the expected results.

=IIf([Line]=1,"First Line",[Line])

Tim
 
1) Make sure that the Line field is included in the report's record source.

2) Check that Line is a numeric field. If it is a text field, you'll need to
add quotes around the value being compared ([Line] = "1").

3) Sometimes expressions will fail if no control on the report is bound to
one of the fields referenced in the expression. It might be necessary to add
a bound text box (bound to the 'Line' field) to the report. You can hide it
by setting its Visible property to 'No'.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Thanks for the input Brendan. I had to rename the Line field to SLine and
it worked just fine. Line must be one of those words that Access has
exclusive use of.

Tim

Brendan Reynolds said:
1) Make sure that the Line field is included in the report's record source.

2) Check that Line is a numeric field. If it is a text field, you'll need to
add quotes around the value being compared ([Line] = "1").

3) Sometimes expressions will fail if no control on the report is bound to
one of the fields referenced in the expression. It might be necessary to add
a bound text box (bound to the 'Line' field) to the report. You can hide it
by setting its Visible property to 'No'.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


TIML said:
I have a simple iif formula inside an unbound textbox. I keep getting an
#Error instead of the expected results.

=IIf([Line]=1,"First Line",[Line])

Tim
Click to expand...
Click to expand...
 
Thanks for the input Brendan. I had to rename the Line field to SLine and
it worked just fine. Line must be one of those words that Access has
exclusive use of.

Tim

Brendan Reynolds said:
1) Make sure that the Line field is included in the report's record source.

2) Check that Line is a numeric field. If it is a text field, you'll need to
add quotes around the value being compared ([Line] = "1").

3) Sometimes expressions will fail if no control on the report is bound to
one of the fields referenced in the expression. It might be necessary to add
a bound text box (bound to the 'Line' field) to the report. You can hide it
by setting its Visible property to 'No'.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.


TIML said:
I have a simple iif formula inside an unbound textbox. I keep getting an
#Error instead of the expected results.

=IIf([Line]=1,"First Line",[Line])

Tim
Click to expand...
Click to expand...
Click to expand...

Actually, Line is not a reserved word.
ANY control name that is the same as the name of a field in it's
control source expression will give the #Error.
It's always a good idea to start with an unbound control when you need
to use an expression in a control (unless you are using field names
like "Text1", "Text2", etc. )
 
Back
Top