Hi! Im trying to disallow the input of " in my name field using the validation rule but i cant seem to get it. Does anyone know how this can be done?

Also what does it mean when i have *x*, what does the 2 * mean?

THanks in advance!

Hi! Im trying to disallow the input of " in my name field using the validation rule but i cant seem to get it.

Put this in the validation rule:

Like <> Chr(34)

* is used as a wildcard to do searches in access.

JR

If you want to give the user a more meaningfull warning, then you can move the validation from the table to your form instead and use some code.

You can use the control's BeforeUpdate event, it will look something like this:

Private Sub Text0_BeforeUpdate(Cancel As Integer)
If InStr(Me!Text0, Chr(34)) Then
MsgBox "Illegal use of quotemark"
Cancel = True
End If

End Sub

Replace text0 with the name of your own control.

A third way is to remove the illegal " from the field for the user by using the replace function. You can use the control's After_update event instead. Something like this:

Private Sub Text2_AfterUpdate()
Me!Text2 = Replace(Me!Text2, Chr(34), "", 1) ' Remove " from string
End Sub

JR

Like <> Chr(34)


This looked unlikely to me so I tried it.
The only thing I could enter was a Null

This is what I would use:

Not Like "*" & Chr(34) & "*"

works well! thanks for the help appreciate it! =D

This looked unlikely to me so I tried it.
The only thing I could enter was a Null


Me too, what was I thinking about :o

works well! thanks for the help appreciate it! =D

Glad you got it to work.

JR