I have an input mask that effectively states the first character in a supplier ref:- "C" and then allows input of 4 alpha then 3 numeric characters.
Mask set in VB as With Me.Supp_Ref.InputMask = ">CLAAA000;_"
The second character in the ref is tested in Before Update for being a "C" or "P". If I enter "P" (or any other alpha character other than "C") then complete the rest of the ref and move to the next field the ref remains as displayed on screen (i.e. CPABC123).
If I enter "C", complete the ref (i.e. CCPABC123) and then move to the next field, the field display drops either the first or second "C" and truncates to 7 characters (i.e. CABC123).
I'm somewhat puzzled as to what's going here, and can't fathom out how to fix, so if someone can point me in the right direction, I would be most grateful!