Author Message

: Any one know if there is an easy way to truncate a currency when writing it to a
: control???

I dont really know what you mean by 'truncating' the currency. But you
can always format the currency figure using FORMAT$. Check out the
usage in the Help file from VB.

: I'm sure there must be!

: Ta for your time

Mon, 08 Sep 1997 09:40:57 GMT  
It really all depends on what you mean by truncate. If I understand the
problem correctly though, the easiest way is to bung the numeric value
into a string, using STR$( <a variable> ).

Then you can use Left$, Right$, Mid$ or whatever other string
manipulation routine comes to hand to chop the number about.

Hope this helps,

Peter Wright.


| Mailing from Psynet Ltd : Providing business with solutions not problems|

Mon, 08 Sep 1997 17:05:54 GMT  
 [ 2 post ] 

 Relevant Pages 

1. concatination question?

2. String Concatination problems

3. Efficient string concatination

4. Concatination of strings

5. string concatination

6. aggregate string concatination


Powered by phpBB® Forum Software