Builiding a custom Zoom Box to display a large amount of data...

[linehand]

Hi apr pillai Hey that is cool that you made that. Nice site too.

Just wondering if what you made will work from subforms and from subforms nested in subforms. And will it work even when the text box is empty before open the zoom? And if the user clicks in the textbox and edits it a little then opens the zoom will it open with the edited text, or just the text as it was when they first clicked on the box?

Those were all problems I encountered - though I managed to solve all of those issues (though my solution for subforms and nested subforms is far from ideal). I also made the large text box on my zoomform scrollable with the mousewheel (though I didn't document the code for that bit here).

I ask because I am sure your solution is probably much better than what I have cobbled together but I would hesitate too use your method for fear of running into all the same problems that I already managed to fix for the method I am currently using.

 

[Danick]

Thank you linehand for all the time you spent in figuring this out and sharing it with us. I had exactly the same problem you were having and your detailed explanation really helped me.

Here was my post that I was asking for help until I spent more time searching this forum and found your solution.

access-programmers.co.uk/forums/showthread.php?t=218421

Good Job!!

 

[smig]

Me.TxtTextField = StrZoomText

if you look carefully at David's code he Update the original form from the ZoomBox form.
That's why he uses the code in the Close event of the ZoomBox:

[FONT=Courier New]Forms(StrOpenForm)(StrZoomControl) = Me.TxtTextField[/FONT]

Forms(StrOpenForm) is the original form, you opened the ZoomBox from (The calling form)
Me. (In this case) refer to the ZoomBox form, not the calling form

 

[Danick]

Hello,

I've been using this zoom box and it's been working very well. It's great for displaying large amounts of data that is for example in a Notes field. But in order to do that, you have to select the Notes field first.

Is there any way to modify this code to allow you to double click a field in the same form (ie the subject field) but instead of zooming that field, it would display the Notes field in the zoom box instead?

Thanks