NA option value

[jwood29]

I have an option box items 1-10 and want to add an NA option.
On the NA option value, I want to put NA, but it says "the value you entered isn't valid for this field". I know this is happening because it expects a number. I do not want a number, I want to Enter NA or leave it null. Is this possible?

This is for an additional comments section, which would not have a score, so the user would choose NA.

Thanks in Advance.

 

[ajetrumpet]

if the field doesn't necessarily have to be a number data type, don't use it. Use Text instead. the number will still show up, but it will be aligned to the right side by default instead of the left. that's the only difference in appearance. If it has to be a number, you're pretty much out of luck, however you could leave it NULL if it is not required. that IS an option.

 

[jwood29]

I do need the field to be a number because I have a text box that is displaying Average of the score field in a report. I just want the NA option for one of the categories and not to have NA or Null included in the Avg.

Thanks.

 

[missinglinq]

When you say "option box" what exactly do you mean? Are you talking about an Option Group, where only one item can be selected at a time, or something else? If it is an Option Group, you could assign it the value of zero, and if you don't want to include this in your Average, use a IF..Then construct or IIF() function to exclude the zero values.

 

[jwood29]

Yep, missinglingq that is exactly what I need.
I have an option group. I can make the NA to equal 0 "zero".
But how do I not include the zeros on the avg in the report?
Right now the control source for this avg in report is: =Avg([eval_score])

Thanks much.