example greyed out text in textbox?

[optionone]

Hi,

Tried searching this forum and the web for an answer to this but not sure what exactly to search for to find an answer

What I am hoping to do is to put some text in a text box that would help the user inputting the data in a similar fashion that a search site would have a text box that might say 'enter search parameters' here - which would disappear once clicked on

Is this too complicated?

Thanks!

 

[John Big Booty]

In the form's On Current Event you could put the following;

    If Me.NewRecord = True Then
        Me.YourFieldName = "Enter Value Here"
    End If

Then in the Form's Before Update event put the following;

If Me.YourFieldName = "Enter Value Here" Then
     MsgBox "Please enter a value"
     Me.YourFieldName.SetFocus
     Cancel = True
End If

 

[John Big Booty]

You could then use Conditional Formatting to format the text "Enter Value Here"
to appear greyed out.

 

[John Big Booty]

...Oh yes, almost forgot to mention that the code presented above will only work for text or memo fields, numeric fields will require a different approach.

 

[optionone]

Appreciate the help John