convert text??

[PQTIII]

I get a text field [pattern] that contains pattern sizes ex.12x12. How do I convert it to a number field for calculations? I've used the Left and Right functions to get the first 2 numbers and last 2. It will always contains two 2 digit numbers.

Thanks
Paul

 

[PHV]

A starting point:
Dim a, x As Long, y As Long
a = Split(Me!pattern, "x")
x = Val(a(0))
y = Val(a(1))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886