Results 1 to 2 of 2
2002-04-25, 21:23 #1
- Join Date
- Mar 2002
- Thanked 0 Times in 0 Posts
MAKING field 'disappear' in form (Access 97)
I am giving a presentation via form and I have several fields on my form. Not all fields have information in them in each record. Is there any way to make the field size reduced when there is nothing in there for that particular record or make the field (and label if possible) disappear when there is no info and reappear when there is. Also, is it possible to make the field size grow and shrink to the amount of text that is in there...some of my fields have a few words and some have sentences.
2002-04-26, 05:45 #2
- Join Date
- Dec 2000
- Sacramento, California, USA
- Thanked 1 Time in 1 Post
Re: MAKING field 'disappear' in form (Access 97)
You can make form field invisible by setting the visibile property of a control to false in the Current event of the form. This does NOT work with continuous forms, since all the visible instances of the control will behave the same way, whether it applies to that record or not.
Although form controls have Can Grow and Can Shrink properties, they only apply if you print the form, not if you just display it. It is possible to change the size of controls through code, but it isn't worth the effort required and you would have to do much more than just change the size of the field.Charlotte