hi

i have a form where i have place the main data on the "Detail" portion. i wish to have a command button on my detail page and when i click on it, the action is to open the page footer where it consists some data which means that the data will only display when the button is clicked.

i have try by making the data visible = false first and in the event of on click event of the command button, i wrote :
me.lblData.visible = true,
however it does not work.

how can i do that??

pls advice
nono

try on form load
Me.FormFooter.Visible = False

and on button click
Me.FormFooter.Visible = true

Is this what you are looking for?

Sal

hi sal,

this is exactly what i wanted. can i ask u one more question?
how can i adjust the form footer. becoz if i have a large amount of data on the form footer then my form size will appear a large blank space on the bottom unless the user click on the command button.

so what i want is that can the form resize itself, which means that when the form load, it will appear in the size where the form footer is hidden (no blank space shown). only after the user click on the command button the form will then resize to the approiate size.

i hope this dont confuse you.

pls advice
:)nono

How about if you put this statement after you make the form footer and label visible?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

hi Greg Serrano,

i have try the method u told me. it wont solve the redundant space. there will be a blank space at the footer when my form loads.

any ideas?

pls advice
nono

Try setting the
CanShrink property to yes and the
CanGrow to yes

Sal

hi sal,

the previous method u taught me was correct after many tries.... but in the first place i have to change the properties of the form footer in order for the visbility to work. glad that u have help me.

thanks a million!
nono

So, I guess it is working now?

:)


Sal

yes of course it works!

thanks again
nono:D