here's what I want to do, tell me if it's possible and if so, how...
My form is in continuous view
I have a text field that can get pretty wordy. I would like to display one line of it but have a little plus sign that would expand it to display the entire content of the field. This would push the latter records down.
I have a diary which has the exact situation you are talking about.
In my case I have a macro that runs OnClick and is attached to the textbox which has my notes associated with the appointment. This macro opens a small form where the ID number fields are the same and the small form is based on the same query as the diary details.