Standard number format?

[asmores]

I have created an access database where a user can enter specific filter information and the database will spit out their specific criteria pulled from a static table. The problem my users are coming into is that some are using a general number format (5000) while others are using a standard format (5,000). My code does not seem to what to accept the commas in the standard format. Does anyone know how i can correct this?
Thank you,

[asmores]

Scratch that, formatting the text box to "General Number" fixes the issue.

[Missinglinq]

Glad you got it working, but for future reference, you can remove a specific invalid character, using the Replace Function:

Private Sub TargetField_AfterUpdate()
 Me.TargetField = Replace(Me.TargetField, ",", "")
End Sub

where the first argument

Me.TargetField = Replace(Me.TargetField, ",", "")

in this case a Comma, is the character to be replaced, and the second argument

Me.TargetField = Replace(Me.TargetField, ",", "")

in this case a Zero-Length String (basically nothing), is the character to replace it with.

Linq ;0)>