Default values just as reference on a form

[Secue]

Hi:



I want to know if there is any way to place on a form some reference on the available fields, for example If I have a field "Name", place on gray inside of the text box "Please enter your name here" but once I select the box, this reference is deleted and I can enter the information. Is like a reference for the users to know what information must be entered on the text box.

Thank you.,

[Missinglinq]

Sure, but it takes some doing, and can only be done on a Single View Form (not on a Datasheet or Continuous View Form):

• Delete the Textbox’s attached Label
• Create new Label for Textbox with the Caption of choice
• Set BackStyle and BorderStyle of the Label to Transparent
• Position Label inside of the Textbox
  

Now, use this code, replacing TargetFieldLabel and TargetField with the actual names of your Controls:

Private Sub Form_Current()

If Nz(Me.TargetField, "") <> "" Then
  TargetFieldLabel.Visible = False
Else
  TargetFieldLabel.Visible = True
End If

End Sub

Private Sub TargetField_GotFocus()
 
  TargetFieldLabel.Visible = False

End Sub

Private Sub TargetFieldLabel_Click()

  TargetField.SetFocus

End Sub

Private Sub TargetField_LostFocus()

If Nz(Me.TargetField, "") <> "" Then
  TargetFieldLabel.Visible = False
Else
  TargetFieldLabel.Visible = True
End If

End Sub

Linq ;0)>

[Secue]

Thank you. This solved my problema.

[Missinglinq]

Glad we could help!

Linq ;0)>