Best Approach

[burrina]

As a continuation of Bad Words, this issue has come up. Your advice Please.

Dim strOldValue As String
strOldValue=me!"txtmsg.value
If Me.strOldValue <> Me.txtmsg Then
MsgBox "You have not edited your message" , "Please Change Wording!"
Exit Sub
End If

Or I could check character count and store old value in textbox
What is your reccomendation?
Object is to see if they have changed the bad word(s) found and if so they can send, else no.

Or Cancel Save!

Best approach Please...

[StuartR]

I think that this whole approach is doomed to fail. At some point in the process you have to trust people, otherwise you are going to prevent them from working efficiently.

[HansV]

I agree with Stuart, but if you really want to prevent bad words, you should check for them in the Before Update event of txtmsg, and set Cancel to True if the message contains bad words. That way, the user won't be able to exit the text box until they have been removed.

[burrina]

I have already coded for variables with some pretty good code if do say so myself. Since this post I resolved the issue. Sometimes its good to think out loud.

Thanks,
P.S. Wrote a whole module to deal with bad words.
Project is 100% not a failure. 2 field name project turns into a challenge but not one that is impossible.

[HansV]

Good to hear that!