Error Message: "The String is non-numeric"

[Chilly1]

I have a field in a table called "Mark" that holds the mark assigned to a course (i.e. 62). The field is a string value, so I have to convert it to a number to do any calculations.

I created a formula called Mark. The formula looks like this: toNumber ({Mark}). This formula does convert the string into a number. However, when I run the report and scroll through the pages, I get about half way through then I get brought to the Formula screen with the message:
"The String is non-numeric".

Does anybody know why I would get this message?

 

[Naith]

ToNumber isn't an airtight conversion function.

Try switching your formula to Val({Mark}) and give it another shot.

Naith