Letters instead of numbers

J

jim

I need a sloution on how to use letters instead of numbers
for numbering of sub topics in a report.


Example:
A. Milk
B. Juice
C. Bread


All the help is appreciated
 
F

fredg

I need a sloution on how to use letters instead of numbers
for numbering of sub topics in a report.


Example:
A. Milk
B. Juice
C. Bread


All the help is appreciated
Click to expand...

I assume you want
A. Milk
B. Juice
instead of
1. Milk
2. Juice

Add an unbound control to the Report section.
Set it's control Source to
=1
Set it's Running Sum property to
Over all (or Over Group if that is appropriate).
You can make this control Not Visible.
Name this control 'RunningCount'.

Add another unbound control.
Set it's Control Source to:
=Chr(64 + [RunningCount]) & ". "

Your good for up to 26 sub topics A-Z per group.
 
Top