Predefined text to a text field with no data.

[sagamw]

If you go to MSDN
like this page

http://msdn.microsoft.com/en-us/library/bb214326.aspx

You have a search box which says (in italics) Search MSDN with Bing. When you click on it, the text disappears for user input. If you don't write anything, it's there again/

Is there a way to have something like this in Access 2007?
I don't mean the default value.
Just a sentence, which after the user clicks in the field will disappear.

 

[dhookom]

You can set the Tag property to your "Search MSDN with Bing". Then add code to your Form Open and text box Got Focus like:

Private Sub Form_Open(Cancel As Integer)
    If IsNull(Me.txtDescription) Then
        Me.txtDescription = Me.txtDescription.Tag
    End If
End Sub

Private Sub txtDescription_GotFocus()
    If Me.txtDescription.Text = Me.txtDescription.Tag Then
        Me.txtDescription = Null
    End If
End Sub

Duane
Hook'D on Access
MS Access MVP