Formatting currency output...
John L
never was a VB guru, but. I can see I'll have to pick up a couple VB5
instruction books - any suggestions on a couple good (basic level) learning
VB books?
Okay - in my database I have a sales total box (textsalestotal) and want to
multiply whatever that figure is by .07617 which is Missouri tax - if I just
use a click event to multiply, for example $30.34 * .07617 I of course get
some number like 2.31099789xxxxx.
For the life of me (been looking over 2 hours) I can't find the format
command to output the answer to a proper currency figure like: Format
(txtsalestotal, "xx.xx") ??
Thanks for any help... :))
John
Veign
--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/
"John L @yahoo.com>" <john_stlmo<removethis> wrote in message
news:wvp0e.15067$EQ1....@fe04.lga...
John L
format - I won't be inputting the number manually and the amount will vary
constantly. I have the data field set to currency - I'm surprised it
doesn't do it automatically anyway...?
Tried that code without success...
Any other thoughts? I used to do this routinely with just a very simply
format expression or truncate process or something -- which I've now forgot
and can't seem to find anywhere.
All I want to do is convert any number within a certain field to currency
format of xx.xx
Thanks for the attempt though - it's appreciated...
John
"Veign" <m...@home.com> wrote in message
news:BSq0e.2499$z.1...@newsread2.news.atl.earthlink.net...
Veign
the number with a variable, field, or whatever...
--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/
"John L @yahoo.com>" <john_stlmo<removethis> wrote in message
news:GKG0e.8744$M34....@fe03.lga...