Generic Zoom Box

[dataside]

I have comments fields on various forms.

These can be used to copy and paste email requests into so can fill up with a lot of data.

The comments field on the form is small so I want to provide a Zoom dialog box to show more of the comments field.

I can't work out how to pass a parameter to the zoom box so that it retrieves the comments field from the correct table. I don't want to hard code the table into the zoom form or create multiple zoom forms for each table as this would create in effect duplicate objects.

Any suggestions?

Thanks

Peter

 

[JoeMiller]

Do the users need to edit the data? I can see making a form with an unbound control. Then when the user double-clicks the comments field the unbound form is opened and the contents of the textbox is shown in whole to them. Now if you want them to be able to edit it, that's not a big deal, you just need to program the data in the box to go back to the control on the form that called the unbound form.

A way to get the data from the field into the unbound box would be to either copy it directly:

MyTextBox = Forms!MyFormName!MyComments

or you could set the default value when the unbound form is opened:

Me.MyTextBox.DefaultValue = Forms!MyFormName!MyComments

HTH Joe Miller
joe.miller@flotech.net