changing height

[Jean-Paul]

Hi,
Depending on the value of a variable, I want to change the height of the
details part of my form...
I can't find the correct syntax...

if variable_name = "J" then
....
endif

Anybody can help?
Thanks
JP

 

[Marshall Barton]

Depending on the value of a variable, I want to change the height of the
details part of my form...
I can't find the correct syntax...

if variable_name = "J" then
....
endif

The height of a form's detail section is the InsideHeight
property less the Height of the form's header and footer
sections (if present). That also assumes that the form is
tall enough for at least the header and footer sections to
display completely.

 

[Jean-Paul]

thanks for the reply but finally, it didn't solve my "problem"

The final idea was:

I have this form that I want to use in 3 different departments of our
school.

The main form contains only pushbuttons in 3 rows
For the department a I only need the upper pushbutton row
department b needs all pushbuttons from the top and the second row
department c needs all pushbuttons.

I can set them invisble (depending on the department that uses the
buttons) but then I have a much to high detial-part... so I thought to
change the height itself.
If I change the height I can not make it that small only the top row is
displayed...

You understand???

Any idea?

mscertified schreef:

 

[Jean-Paul]

I can not make the height less the 9 cm
when I make the pushbuttons invisible it seems acces doesn't allow less
heigh form
I really would like to use an ordinary form without tabs just to keep it
simple for me

JP

mscertified schreef:

 

[Marshall Barton]

Don't waste time trying to manipulate a form's detail
section Height, it won't do what you want. Also, you can
not make a section hide controls just by making the section
smaller. If you want to make a section smaller, you will
have to move the controls out of the way by setting their
Left/Top property.

OTOH, setting the form's InsideHeight property can make the
form (not the detail section) too short to display all the
controls. The effect is easy to see just by dragging the
form's border to resize the form.