Written dollars on a check

[vlingen]

Hi All,

I'm working on creating a Check and my issue is on the line where it writes out "Twenty-five dollars" or whatever the amount is. I have the written words, but I need to add the "*****" to fill up the blank space.

I'm missing the function that fills in the "****" for a select number of spaces. The total Length of the line should be 100 characters.

=English(Sum) returns the words that I need.

FoxPro had a function called PADR() which fills in the remaining with whatever character you want... but I don't see this in VBA/Access.
So I'm thinking it should look something like

=English(Sum) + PADR(LEN(English(Sum)) - 100, "*")

so what I need is a way to tell it how many "*" to enter to the right of the "Twenty-five dollars"

Thanks!

 

[combo]

VBA: String function.

combo

 

[Andrzejek]

How about

MsgBox 100 - Len(English(Sum))

So if "Twenty-five dollars" takes 19 characters, [tt]Len(English(Sum))[/tt] should give you 19.

100 - 19 = 81

You need 81 *'s

Have fun.

---- Andy

 

[SkipVought]

"...to fill up the blank space"

Be sure to use a FIXED PITCH FONT like Courier

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[randy700]

Left(English(Sum) & String(100, "*"), 100)

Randy