By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
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

✓ answered by 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

Share this Question
Share on Google+
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

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

twinnyfo
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
  1. =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

Post your reply

Sign in to post your reply or Sign up for a free account.