As you found, Val() can't handle strings that are formatted with characters
such as % or $. Divide the value by 100, i.e. use:
In what context do you need such a value entered? If it is an unbound text
box, set its Format property to Percent, and it will be understood correctly
as a numeric value.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Wavequation" <Wavequation@discussions.microsoft.com> wrote in message
> I am using the following code:
> where strValue = "0.1%"
> I am getting a type mismatch error.. what does the "%" character
> do to a string?