tols12
asked on
How do I make the notes subform shrink/grow depending on how much text i have in the field?
I created a notes subform. In that subform, one of the column is called notes. I also have another column called date. Some of my notes are really long. Others are really small. How do i make it so if my note is small, the row shrinks so the row isn't huge. Also, if the text is really long, how to i make it so the row gets bigger to show all of the text? I tried highlighting the date and notes fields, the selecting "Yes" to "Can Grow" and "Can Shrink". But that didn't work. What else am i missing? THanks!!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok. I have everything set to shrink/grow. I think click on the print button you helped me with earlier, but it still desn't shrink. I checked both the report and form, everything is set to shrink and grow. When i print the report, it still doesn't shrink or grow.
Kind of hard to troubleshoot ... can you upload ... and explain exactly how to reproduce the problem ?
mx
mx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sample attached
You can obviously open the report on it's own to view all the records with their associated "Notes" filed/controls properly sized to fit the text.
;-)
JeffCoachman
Database521.mdb
You can obviously open the report on it's own to view all the records with their associated "Notes" filed/controls properly sized to fit the text.
;-)
JeffCoachman
Database521.mdb
...or you can just use a messagebox, to display the full notes, depending on your needs:
msgbox me.txtNotes
msgbox me.txtNotes
ASKER