Me.FormFooter

[PatAccess]

Good day All and Happy Friday!

Does anyone knows of a VBA code to move the form footer up and down based on rather there are objects there or not?
I saw the Me.FormFooter but I went through the list and can't seem to find anything

Thank you,

 

[BigHappyDaddy]

Not sure if I understand correctly, but you can change the Height of the form footer, but where it appears it determined by where the detail section ends.
So to have the footer appear lower on the screen, increase the height of the detail section.

Does that make sense?

 

[PatAccess]

Yes I understand, I have a form where certain controls appear if something happen and when those control disappear, I would like to footer to move up so actually I need the detail section to shrink automatically under the last visible control.
I hope I make sense

 

[CJ_London]

for forms, if you want to keep the height of the footer the same you have to adjust the size of the form window - which won't work for tabbed windows, they need to be overlapping windows (or popups)

if you want to adjust the height of the footer the code will be something like

me.section(2).height=insideheight-me.section(1).height-(me.section(0).height*me.recordcount)

you will probably need code to ensure you don't use a recordcount value which would push the footer off the screen

 

[PatAccess]

Ok I'll try that. Thank you