I am trying to write a formula to bring up a message box if a field is less than 15 digits but don't want it to appear if it is not populated at all. Currently I have the following:
@If(@Length(Fieldname)!=15 & @IsDocBeingSaved;@Failure("Please enter a valid 15 digit number.");@Success)
This brings up the message box if it is under 15 digits but also when it is blank, how can i incorporate this. I thought perhaps I could do the @Length is between 1 & 14 (inclusive) or is >0 and <15 but can't seem to get this to work..
Any advice gratefully received.. Thanks...