How to Expand Form to Show Addtional Fields

[Guest]

I have:
A form with many fields. Some field are rarly used.

I want:
To hide some fields when the form opens. When a user clicks a "Details"
button, the form will expand to reveal the additional fields. Is this easy to
do in Access?

Any suggestions?

 

[Dave Miller]

Set the field property "Visible" to No. This ensures that these fields
will not be visible when the form opens. Then use this code for the
button click:

Private sub Details_Click ()
with me.
.txt1.visible = true
.txt2.visible = true
end with
end sub

David Miller

 

[Guest]

Hi Dave,

will this simply show the fields in the space allocated for them in design
mode or will it actually expand the length of the form.

thanks

richard