Good morning all,
I have 4 unbound controls on a subform. The first control tests and strips away unwanted leading characters:
Name: txtADJ_POLICY
=Nz(IIf(Left([POLICY],1)="R",Mid([POLICY],3,Len([POLICY])),IIf(Left([POLICY],1)=0,Mid([POLICY],2,Len([POLICY])),[POLICY])),"")
Name...