Validate only the first character of field in Navision.

kolaboy

Hi Experts,

if "Account No." <> '' then
if not ("Account No."[1] in ) then
Error(TextXXX);

This is currently working with first Characters with A or B. But after typing the first Character with A Or B, it allows other letters to follow.

What i want in addition to this is to let it accept only the Letters A or B as first letters then followed by four digit Numbers. It should not allow anyother letter apart from A or B and They should not be repeated. Only A and four digit nos or B and Four digit nos.
The Nos. too should not exceed four digits. What modification can one do on the above code?
Any idea on this.

David_Cox

Hmmm! easy!
i = variable Integer

IF "Account No." <> '' THEN 
   IF (STRLEN("Account No.") <> 5) OR 
      NOT(EVALUATE(i,COPYSTR("Account No.",2))OR
      NOT("Account No."[1] in ['A','B']) THEN   
   ERROR(TextXXX); 

kolaboy

Hi David,
Thanks you very much. It has worked. \:D/

kolaboy

Hi David,
Thanks you very much. It has worked. \:D/

David can you look at the post topic for me and see if you can help me solve that last problem. the topic is :How to count No. of Months.
Please.
thanks.