Unbound text box - how to display a light grey text in the box?

[TAM]

I have an unbound box and the user has the ability to enter in either a last name or rep ID. Once the information is entered, we run a macro which applies a filter based on the inputs in the box. I have that part working and am curious.

I've seen forms where there is light grey text in the box to let the user know what they can enter in the search box. Can I do that with ACCESS and if so, please share.

Thanks!!

 

[healey21]

It should be just a case of changing the format property. Please supply the name of the unboundbox and either change the caption value of the label.

 

[TAM]

It should be just a case of changing the format property. Please supply the name of the unboundbox and either change the caption value of the label.

Unbound Box Name is called: Search_Team. I updated the "Datasheet Caption" to say "Enter ID or Name", but it's not displaying that as greyed text within the search box as I had anticipated.

 

[Trevor G]

Try this code if not try setting Conditional Formatting.

Private Sub Form_Open(Cancel As Integer)
Me.Search_Team.ForeColor = RGB(206, 192, 192)
Me.Search_Team.Value = "Find me"

End Sub