Problem in displaying a text box in access form in controltip text

[Jack]

Hi,
I have a text that has memo in the backend field. The contents of the fields
are large compared to the size of the field. I would like to user to see the
value of the text box by using the controltip text feature.

I am using the code as above.

Me.TextBox1.ControlTipText = Me.TextBox1

Now when I am stepping through the code I am getting the following message:
THe settting of property is too long. I got this code in the onlcick event
of the text box where I would like to display the contents of the textbox via
the controltip text tool. I am not sure where I am going wrong. I appreciate
any help for resolution of this issue. Thanks.

 

[Damon Heron]

Yes, you have discovered the limit of control tips. As one alternative, you
could use the zoom command, but I like to make my own zoom form, as it
allows me more control over the font size, nice and big for readibility.

I use a click event to open the form, frmZoom:
DoCmd.OpenForm "frmZoom", , , , , acDialog

In the zoom form open event, I have:
Private Sub Form_Open(Cancel As Integer)
Forms!frmAccountTransactions.[subfrmTransactions].Form!TransactionDescription=
Me.txtBigNotes.Value
End Sub
'where the data on my main form (in this case frmAccountTransactions) is
written to txtBigNotes, a field on my zoom form...(Substitute your own form
name and subform, if any)....

In the Close Button event of frmZoom:
Forms!frmAccountTransactions.[subfrmTransactions].Form!TransactionDescription
= Forms!frmZoom!txtBigNotes
it copies the data back to allow for any changes made. If changes are not
allowed, omit this step.
I also have a Cancel Button that simply closes frmZoom without making
changes.

Damon