I've been pulling my hair out, hope somebody here can help.
I have Access 2000 (SR-1) and I'm attempting to get the Can Grow/Can Shrink properties to work on a text box in a form. I ran across one message here that says Can Grow/Can Shrink doesn't work in forms, but the Access help says otherwise. Plus, the Can Grow/Can Shrink properties are right there in the properties dialog while I'm designing my form.
I did a database in Access 97 a few years ago that successfully used Can Grow in a subform, but I don't have access (no pun intended) to it at the moment. Even if I did, I'm afraid I'll find what I usually find in situations like this; for all intents and purposes the implementation will *look* exactly the same but won't work in the new database
.
Could somebody give me the straight dope on this? I'm building a contact manager for a company that needs some custom stuff and I am trying to duplicate the behavior of ACT! as seen in this picture http://www.act.com/image/page-3-3.jpg in the bottom half of the app where you can enter line items of detail when a customer calls, and the memo field where you store call notes will take up as much room as they need to and it pushes the rest of the line items downward.
It's funny... 99% of the stuff I do in Access takes 1% of the time, but that 1% (this problem, for example) takes the other 99% of the time!
Would appreciate any help anyone could give me.. I just discovered these forums and if they're helpful, it'll be a godsend.
-Mark
I have Access 2000 (SR-1) and I'm attempting to get the Can Grow/Can Shrink properties to work on a text box in a form. I ran across one message here that says Can Grow/Can Shrink doesn't work in forms, but the Access help says otherwise. Plus, the Can Grow/Can Shrink properties are right there in the properties dialog while I'm designing my form.
I did a database in Access 97 a few years ago that successfully used Can Grow in a subform, but I don't have access (no pun intended) to it at the moment. Even if I did, I'm afraid I'll find what I usually find in situations like this; for all intents and purposes the implementation will *look* exactly the same but won't work in the new database
.Could somebody give me the straight dope on this? I'm building a contact manager for a company that needs some custom stuff and I am trying to duplicate the behavior of ACT! as seen in this picture http://www.act.com/image/page-3-3.jpg in the bottom half of the app where you can enter line items of detail when a customer calls, and the memo field where you store call notes will take up as much room as they need to and it pushes the rest of the line items downward.
It's funny... 99% of the stuff I do in Access takes 1% of the time, but that 1% (this problem, for example) takes the other 99% of the time!
Would appreciate any help anyone could give me.. I just discovered these forums and if they're helpful, it'll be a godsend.
-Mark
