Seeing Entire Field

[MtBob]

Some of my fields are hundreds of characters long. How do I see the entire field for easier editing without having to scroll back and forth? I want it to be like Excel where it shows me the entire field at the top. Or at least allowing me to switch views to see the entire field. Any thoughts? We use Access connecting to an SQL Server DB

 

[dgm]

This won't help u edit the text at all, but will allow u to see all the text without scrolling.

Private Sub txtField1_Enter()
    If Not IsNull(Me.txtField1) Then
        txtField1.ControlTipText = txtField1
        txtField1.StatusBarText = txtField1
    Else
        txtField1.ControlTipText = ""
    End If
End Sub

This actually uses 2 different methods. The first one sets the data in the field to be displayed as the controltip text that appears when u hover the mouse over the field. The second method displays the data in the field in the status bar.

I find the status bar text doesn't always work, not sure why though. And u have to click in the field before it will display.

Hope that helps.

 

[MtBob]

Pat. Outstanding! That is perfect. Exactly what I needed. Thanks. (I pulled the shortcut menu button "Zoom" into my toolbar as well.) Thanks!

 

[Rich]

DoCmd.RunCommand acCmdZoomBox on the double click event of your text box is another option