Access validation rules to ensure accurate data entry

[sroy]

I have input boxes in access form. I want to limit entry of * in one of the input fields named "Name" anyway If * is found anywhere in anyform of data entry then it should show warning.

[RuralGuy]

The best place to do input validation is the BeforeUpdate event of a control.

[sroy]

I am novice !

[sroy]

I am not able to do it.

[RuralGuy]

Do you have *any* experience with VB or VBA?

[sroy]

Very little !!!

[RuralGuy]

As with most things in Access, there are several way to do this depending on what you actually want to happen. Do you want to warn the user but let them enter the "*" anyway?

[sroy]

On Design > conditions >
Macro named: abc
Condition : [Name]="*"
Action: Msgbox

Message: * can not be entered.

But if I enter * after any text, symbol etc it didn't show up the warning. I want something more perfect as in my first post requirement.

[sroy]

I want to warn the user but let them do not enter the "*" anyway.

[RuralGuy]

I want to warn the user but let them do not enter the "*" anyway.

"let them do not enter the "*" anyway"...you lost me.

[orange]

* has special meaning in Access, it may be interfering with your efforts.
You may, guessing, be able to use something like [*]????

[sroy]

RG: I want to warn the user when they enter the "*" anyway. The warning should appear if any number of time the user tries to enter * anyway.

[RuralGuy]

Do you want the user to *have* to respond to the warning by pressing a button or something?

[sroy]

I think responding to the warning by pressing a button is better RG.

[RuralGuy]

Try something like this in your control:

Private Sub YourControlName_BeforeUpdate(Cancel As Integer)
   If InStr(Me.YourControlName, "*") Then
      MsgBox "You are using and asterisk '*'", vbCritical + vbOKOnly
   End If
End Sub

...replacing YourControlName with your control name of course.