By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,066 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,066 IT Pros & Developers. It's quick & easy.

Access 2003 Report Group Levels

P: 23
In Access 2003, I'm creating a dynamic report and am trying to place text boxes into group headers. One report will have 6 group levels. I can place controls in the first two group headers easily by using the acGroupLevel1/2Header option. How do I place in the other group headers? acGroupLevel3Header doesn't appear to exist and manually typing it doesn't seem to work.
Sep 9 '08 #1
Share this Question
Share on Google+
1 Reply


Megalog
Expert 100+
P: 378
quoted from Allen Browne:

"From memory, you can create up to 10 group levels.
The lack of constants won't stop you.

In the code window, press F2 to open the Object browser.
Search for:
acGroupLevel2Header
You see it is a memeber of acSection, which also contains:
acGroupLevel1Header = 5
acGrouplevel1Footer = 6
acGroupLevel2Header = 7
acGrouplevel2Footer = 8

Can you guess what numbers you might need to use for the 3rd header and
footer?

You could create your own constants if you wish:
Const acGroupLevel3Header As Long = 9
Const acGrouplevel3Footer As Long = 10
and so on."
Sep 9 '08 #2

Post your reply

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