Complex Input Mask

[Geoff Codd]

I've got the following piece of code which selects an input mask based on the customer order type

Select Case Me!CustomerOrderType

Case 1
' Set Order / Survey Number Input Mask based on Order Type
Me!OrderSurveyNumber.InputMask = "E-0000000;0;_"

Case 2
Me!OrderSurveyNumber.InputMask = "P-0000000;0;_"

End Select

The code works fine for case 1, as the number is supplied to us from an outside company. The problem is with case 2 where I need the Order Survey Number to act like an auto number field.

Thanks in advance

 

[David R]

Please don't post your questions in more than one Forum. If you can choose one it belongs in, use that. Otherwise General is always a safe bet.
Jack Cowley has already answered your identical posting here: http://www.access-programmers.co.uk/ubb/Forum1/HTML/007252.html
Post a reply in that thread if you need more assistance and someone will hopefully be able to help further.

Good luck,
David R