covert special text to number

[masoud_sedighy]

hello



in my table there is a text field that it's type is text. and is something like this "1390/02/01"now i like to remove these "/" and use that like number for example "13900201" in the VBA code. because i want to use it in the if statement like below.please help how i can?

int number1=13920223
text1="1390/02/01"

after changing text1 to number2

if (number1>13900201)

{

}

Best regards.

[Missinglinq]

You can use the Replace() and Val() Functions to do that, where TargetField is the name of the Control holding the original data:

Val(Replace(Me.TargetField, "/", ""))

will take

1390/02/01

convert it to

13900201

and allow Access to see it as a Number.

Linq ;0)>