Add fill characters to ConvertCurrencyToEnglish code

[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

[Mike MacSween]

"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

[Mike MacSween]

"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

[Tom C]

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

[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