Notes/Domino 4 and 5 Forum

Hi,

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...