As you found, Val() can't handle strings that are formatted with characters
such as % or $. Divide the value by 100, i.e. use:
0.001
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
news:31D8D7B4-4C76-4C0C-8FDE-DA313AF19D51@microsoft.com...
> I am using the following code:
>
> Val(strValue)
>
> where strValue = "0.1%"
>
> I am getting a type mismatch error.. what does the "%" character
> do to a string?