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?

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" <(E-Mail Removed)> wrote in message
news:31D8D7B4-4C76-4C0C-8FDE-(E-Mail Removed)...
> 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?