Calculating Combo Box

[sandylt]

I have a score sheet with 43 categories. Each category has a combo box with a range of 0-5 or X. The number would equal face value and X would equal 0. The problem I am having is how to score it. I cant total the combo boxes because they are text boxes due to the use of X. The only thing I can think of is to have an unbound box for each category and an If statement of each one. I was wondering if there was a better way before I start plugging away.

 

[Jings00]

I would use a form of following to convert the text score to numbers:

ValueScore: IIf([textscore]="x",0,CInt([textScore]))

 

[sandylt]

Where would I put that?

 

[sandylt]

Is there a global solution?