Unless you are doing math on the apartment number, I'd strongly suggest that you use a text field instead.

Either just go ahead and use a numeric (if you are doing numeric operations on them - like a numeric sort), or use a leading zeros and fixed size - stripping them off before other uses. If you must use a numeric in a word merge, use Word's merge field switches to set the formatting however you would like.

Rick -

Thanks for your input.

Actually, I designed this for a specific complex and - if an when I wish to do one for another complex - I will simply copy this one and make whatever changes are needed.

Actually, we do have the letter "A" for one building and I was using a "substitute" until I decided how I wanted to handle it.  That building is 12A (in lieu of 13).

In any event, I wasn't completely thrilled with the earlier recommendations, so here's how I resolved it.

I made the Bldg and Condo Unit a TEXT field as had been first suggested.

HOWEVER, I added a "shadow" field that was numeric and used solely for sorting purposes.  So now I can sort on the sortBldg# and use 13 but do whatever work is needed using the text field (so what the users see is 12A).

Thanks for all the help guys.

Another option is to use one of the latest versions of WordMerge (versions 2.5 Nov 2008 and 3.0 Apr 2010).

They will produce formats in the Word document that exactly match the way they appear on the Sesame form, without needing to setup mergefield switches in Word. So, even a true number field that is formatted to display zero decimal digits on the Sesame form, will have zero decimal digits in the resulting merged Word document.