Ralph Gould
asked on
access forms: Have small text box, would like to expand to full screen on double click
I have a sub-form with a small, single text box that users enter comments into. I would like to expand this to a full screen on a button click or something to make the comments more readable. the access shift F2 zoom box is not large enough.
ASKER CERTIFIED 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
PatHartman the subform is already displaying the record in the small text box. I want to popup a larger, read only display of the same info
And I told you how to do that. The F2 is free. Anything else, you have to build yourself. If you don't want to allow edits. Set that to no also.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Look at sample
DBComments.accdb
DBComments.accdb
ASKER
Als315 & Gustav Brock; Thank you for the examples!
The small text subform is already loaded with text from a very complex query. I do not want to issue another query for this. I want to refer to the small sub form text box to extract the text.
tks
The small text subform is already loaded with text from a very complex query. I do not want to issue another query for this. I want to refer to the small sub form text box to extract the text.
tks
If you prefer, you can also use the OnOpen event of the popup form to retrieve the text from the main form.
/gustav
/gustav
The popup form can be unbound. Use something like the following as the ControlSource for the big text box.
=Forms!firstform!txtSmallt extbox
Although, if the small textbox is updateable, I'm not sure why you don't want this form to allow updates. It will just annoy the user or he won't bother to open the big textbox.
=Forms!firstform!txtSmallt
Although, if the small textbox is updateable, I'm not sure why you don't want this form to allow updates. It will just annoy the user or he won't bother to open the big textbox.
ASKER