Formatting data size Single to a percentage

[RPB]

When I use an expression to calculate a percentage the target field is Dim X as Single. It works but the result is 9.982935E-02. I have tried the Format(x, "Percent") and it gets an error 13 "Type Mismatch". I've tried virtually every combination of data types and I've run out of bullets. Any help would be appreciated.

[ranman256]

in the query that does the calc, set the field format to %.

if you do this in code, you may be getting a string. Can you not just use a query?

[RPB]

Here's the vba code that invokes an error:

Dim v_Temp_Prcnt as (I've tried single, double, integer and string)

v_Cancer_Type_Prcnt = cnt_Type / 1172
v_Temp_Prcnt = FormatPercent(v_Cancer_Type_Prcnt, 2) (this is the line that invokes the error)

I have used a query to do the same thing and it works. I'm attempting to automate the process that gathers lots of data and it was easier to write some vba than it was to create umpteen queries that would have to be changed every time the data is refreshed. I have read some posts that percentages in VBA are difficult and I can't seem to find the right combination of data types that will create the desired results.

[ranman256]

=Format(field,"percent")
=Format(field,"0.00%")

but you assign it to a textbox or a variable that can hold it.
assigning a percent to a single does not produce a pct.
Format is just a way to view the #.

[RPB]

Problem solved! I created a text box control on a form (as you suggested) in the UI, moved the re-formatted value there and it works. Thanks.