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

Subform Form header-footers not visible

P: 32
Hello,
I am working on an application in MS Access. I have an employee form with an employee charges subform. the subform is supposed to be displayed in the datasheet view.
I have put the labels for column headers in the form header, and the charges total in the form footer.
What happens is , the header and footer are visible both on the subform and the parent form in design view, but neither appears in run mode. I have gone through every property in both forms, but cant seem to figure out what the problem is.
Please help. thanks in advance

Nanda ramaswamy
Aug 9 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Hello,
I am working on an application in MS Access. I have an employee form with an employee charges subform. the subform is supposed to be displayed in the datasheet view.
I have put the labels for column headers in the form header, and the charges total in the form footer.
What happens is , the header and footer are visible both on the subform and the parent form in design view, but neither appears in run mode. I have gone through every property in both forms, but cant seem to figure out what the problem is.
Please help. thanks in advance

Nanda ramaswamy
Datasheet view is a 'table' view, it will not allow you to display 'form' headers and footers. One way to get around this is to change your form to continuous, this will populate with rows (similar to a table) but also allow the viewing of the form header and footer...

Another way is to use a listbox instead of subform. Your column headers are then much easier to display, and the resulting totals can be placed in your main form area immediately below the listbox.

Regards,
Scott
Aug 9 '07 #2

Post your reply

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