Lettering Bullets in MS Access Reports

[pwag]

Good Morning Pro's,

I'm in search of a solution in MS Access Reports. I'm aware of the Number bullets trick where you set control source of text box =1 and Running Sum(over the group). I was curious if someone had a "relatively" straightforward solution for Lettering over a group instead of numbers. Kind of like MS Word does. So final appearance would look kind of like this.

A.
B.
C.
D.

Thanks Everyone!
P

[jimatqsi]

How about make the running sum invisible and the visible text would be the value of CHR(sum+64), 65 being an upper case A?

Jim

[pwag]

Jim,

That nailed it. =Chr([BulletNumber]+64)

Thanks!
P

[Rabbit]

Note that this only works to a maximum of 26 rows.

[twinnyfo]

I do have a function that calculates rows beyond 26. It's very simple, actually:

=IIf([Rank]<=26,Chr$([Rank]+64),Chr$([Rank]+38) & Chr$([Rank]+38))

This will cover up to 52 items, listing "A, B, C, ... X, Y, Z, AA, BB, CC, ..."

Minor mods could be done to get other effects ("AA, AB, AC, ..."). It has been very useful for me over the years.

[pwag]

twinnyfo,

That's great as well. In this case it's sub-data so I'm hoping 52 items would be enough. Great contribution.