Hey all - sorry if this has been answered somewhere before - but I'm having a heck of a time finding right answer.

I'm using VB 2008 and reading data from an access 2003 database.
I have a query setup in access - read in as a 'view' in vb ... that is showing results of first pass yield. total good parts... total bad parts... and percentage of yield. in my access query - i have the percentage displaying properly using the column format in access... however - on my form -
the data source comes in as a textbox...by default.

I can't seem to google the right question - but right now on my form, even though the dataset recognizes it as a double precision number - the option in the datasource tab - shows it as a text box or data grid right ...

so on my form i have the text box or details option... but my text box shows the percentage as a long decimal ... .98936524 or whatever...

what's the correct string i need to format the textbox.text to display a percentage?

I tried format(val(textbox.text), 0.00) that didn't do anything...
and I did this under the form load section after the data sets were filled.

thanks for any suggestions... I'm at a loss.