I need a lil help with this statement. =IIf([MonthsOfLoan]=1,".10",IIf([MonthsOfLoan]=2,".20",IIf([MonthsOfLoan]>=3,".30")))
Im using this to autofill a text box on a form. The text box is formated as "Percent".
[MonthsOfLoan] is a combo box with a value list of 1 thru 12.
When using the above statement the output is wrong. Example: [MonthsOfLoan] =1 there is no data in the text box. When [MonthsOfLoan]=2 the output is .10. When [MonthsOfLoan]=3 the output is .20, and when [MonthsOfLoan]=4 the output is .30.
The autofill is returning the next value and the format is not correct in the text box.
I need the text box to autofill with: 10% if [MonthsOfLoan]=1 or 20% if [MonthsOfLoan]=2 or 30% if [MonthsOfLoan]=3 or more.
Any suggestions would be helpful. Thanks