By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,501 Members | 2,681 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,501 IT Pros & Developers. It's quick & easy.

IIf functions in forms

P: 2
In this text box enter an IIF function that will check to see whether the customer was born before January 1, 1954. If so, display Eligible for Senior Discount in the text box. Otherwise donít display anything in the textbox.

=IIf([Birth Date]<#1/1/1954#,"Eligible for Senior Discount",[IsNull])

I was wondering what is wrong with this formula??
i get #Name? displayed on my box!
Feb 17 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,597
In this text box enter an IIF function that will check to see whether the customer was born before January 1, 1954. If so, display Eligible for Senior Discount in the text box. Otherwise donít display anything in the textbox.

=IIf([Birth Date]<#1/1/1954#,"Eligible for Senior Discount",[IsNull])

I was wondering what is wrong with this formula??
i get #Name? displayed on my box!
It's simply your syntax ([IsNull] refers to a Field named IsNull not the value Null). This should work:
Expand|Select|Wrap|Line Numbers
  1. = IIf([Birth Date]<#1/1/1954#,"Eligible for Senior Discount",Null)
Feb 17 '07 #2

P: 2
It's simply your syntax ([IsNull] refers to a Field named IsNull not the value Null). This should work:
Expand|Select|Wrap|Line Numbers
  1. = IIf([Birth Date]<#1/1/1954#,"Eligible for Senior Discount",Null)
Perfect!!! it worked! thanks a lot ! :)
Feb 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.