459,576 Members | 1,360 Online
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

# Lettering Bullets in MS Access Reports

 P: 28 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 Jun 19 '14 #1

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

5 Replies

 Expert 100+ P: 1,240 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 Jun 19 '14 #2

 P: 28 Jim, That nailed it. =Chr([BulletNumber]+64) Thanks! P Jun 19 '14 #3

 Expert Mod 10K+ P: 12,430 Note that this only works to a maximum of 26 rows. Jun 19 '14 #4

 Expert Mod 2.5K+ P: 3,483 I do have a function that calculates rows beyond 26. It's very simple, actually: Expand|Select|Wrap|Line Numbers =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. Jun 20 '14 #5

 P: 28 twinnyfo, That's great as well. In this case it's sub-data so I'm hoping 52 items would be enough. Great contribution. Jun 20 '14 #6