rept function in access??

[mmohon]

I use the Rept function to do little "In Cell" bar graphs in Excel. Is
there a similar function in Access, so I can dress up my reports a
little bit?

just to clarify
=rept("@",5) results in "@@@@@"
I wanna do a
=rept("g",[Total Cases]) use Webdings font, and lower case g returns a
solid block which makes a nice little bar graph.

 

[Matthias Klaey]

I use the Rept function to do little "In Cell" bar graphs in Excel. Is
there a similar function in Access, so I can dress up my reports a
little bit?

just to clarify
=rept("@",5) results in "@@@@@"
I wanna do a
=rept("g",[Total Cases]) use Webdings font, and lower case g returns a
solid block which makes a nice little bar graph.

In Access, use

String( 5, "@")

HTH
Matthias Kläy

 

[Dirk Goldgar]

I use the Rept function to do little "In Cell" bar graphs in Excel.
Is there a similar function in Access, so I can dress up my reports a
little bit?

just to clarify
=rept("@",5) results in "@@@@@"
I wanna do a
=rept("g",[Total Cases]) use Webdings font, and lower case g returns
a solid block which makes a nice little bar graph.

So the Excel Rept function repeats a character? The VBA String()
function does that, but with the arguments reversed:

=String(5, "@")
=String([Total Cases], "g")