By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

Add fill characters to ConvertCurrencyToEnglish code

P: n/a
TS
Hi,
I'm using the ConvertCurrencyToEnglish module readily available on the
internet to convert some currency figures to text. However, I want
the code do one additional thing and I'm not sure how to go about it.
I want the data field to fill a particular size of space on my form,
and I want the area that does not include text from the currency
converstion to be filled with some sore of symbol like "*******" or
"///////////". So for example if my data read "15.25", the field on
the form would show as "Fifteen Dollars and Twenty-Five
Cents************************************". What's the best strategy?
Should this additional functionality be part of the ConvertCurrency
code or should I create an additional module that works on top of it?
Any guidance would be appreciated. Thanks.
Teek
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"TS" <ps*****@ix.netcom.com> wrote in message
news:4a*************************@posting.google.co m...
Hi,
I'm using the ConvertCurrencyToEnglish module readily available on the
internet to convert some currency figures to text. However, I want
the code do one additional thing and I'm not sure how to go about it.
I want the data field to fill a particular size of space on my form,
and I want the area that does not include text from the currency
converstion to be filled with some sore of symbol like "*******" or
"///////////". So for example if my data read "15.25", the field on
the form would show as "Fifteen Dollars and Twenty-Five
Cents************************************". What's the best strategy?
Should this additional functionality be part of the ConvertCurrency
code or should I create an additional module that works on top of it?
Any guidance would be appreciated. Thanks.
Teek


Feed your converted amount into a function like this:

Right(String(50, "*") & yourConvertedValue, 50)

The 50 could be whatever number of characters you needed to fill the space
you've got. This works a lot better with a monospaced font like courier.

HTH, Mike

Nov 12 '05 #2

P: n/a
"Mike MacSween" <mi***********************@btinternet.com> wrote in message
news:403c4cda$0$4098
Feed your converted amount into a function like this:

Right(String(50, "*") & yourConvertedValue, 50)


OK, read the question first Mike.

Left(yourConvertedValue & string(50, "*"), 50)

Sorry, Mike
Nov 12 '05 #3

P: n/a
Teek,
Try this solution. It sounds like it just might work for your problem:

Knowldge Base Article ID: Q117911
NF: How to Create a Dot Leader Between Fields

Using the function in this article, you can use any character for the filler

Hope this helps some.

Tom C

Copyright (c) Microsoft Corporation. All rights reserved.
"TS" <ps*****@ix.netcom.com> wrote in message
news:4a*************************@posting.google.co m...
Hi,
I'm using the ConvertCurrencyToEnglish module readily available on the
internet to convert some currency figures to text. However, I want
the code do one additional thing and I'm not sure how to go about it.
I want the data field to fill a particular size of space on my form,
and I want the area that does not include text from the currency
converstion to be filled with some sore of symbol like "*******" or
"///////////". So for example if my data read "15.25", the field on
the form would show as "Fifteen Dollars and Twenty-Five
Cents************************************". What's the best strategy?
Should this additional functionality be part of the ConvertCurrency
code or should I create an additional module that works on top of it?
Any guidance would be appreciated. Thanks.
Teek

Nov 12 '05 #4

P: n/a
TS
Thanks Tom & Mike. I'll try both and see which one works, or should I
say which one I can get to work. Thanks.
Teek
"Tom C" <ct**@simflex.com> wrote in message news:<40******@news.simflex.com>...
Teek,
Try this solution. It sounds like it just might work for your problem:

Knowldge Base Article ID: Q117911
NF: How to Create a Dot Leader Between Fields

Using the function in this article, you can use any character for the filler

Hope this helps some.

Tom C

Copyright (c) Microsoft Corporation. All rights reserved.
"TS" <ps*****@ix.netcom.com> wrote in message
news:4a*************************@posting.google.co m...
Hi,
I'm using the ConvertCurrencyToEnglish module readily available on the
internet to convert some currency figures to text. However, I want
the code do one additional thing and I'm not sure how to go about it.
I want the data field to fill a particular size of space on my form,
and I want the area that does not include text from the currency
converstion to be filled with some sore of symbol like "*******" or
"///////////". So for example if my data read "15.25", the field on
the form would show as "Fifteen Dollars and Twenty-Five
Cents************************************". What's the best strategy?
Should this additional functionality be part of the ConvertCurrency
code or should I create an additional module that works on top of it?
Any guidance would be appreciated. Thanks.
Teek

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.