You don't say where you're trying to do this, but the general syntax, in VBA code, would be something like this, for the data entered into a Control named YourControlName:
You could also use Replace() in SQL/Query, although it would be a little more complex.
Private Sub YourControlName_AfterUpdate()
Me.YourControlName = Replace(Me.YourControlName, "*", "")
Me.YourControlName = Replace(Me.YourControlName, "-", "")
Me.YourControlName = Replace(Me.YourControlName, "/", "")
BTW, I actually took a VB6 programming class from a guy who worked his way through college doing programming for NASA's Apollo Program! According to him, Apollo 11, the first mission to land a man on the Moon, actually had less computing power on board than in found in today's average laptop!
Last edited by Missinglinq; 08-10-14 at 22:35.
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007