[RBASE-L] - RE: Form Format Mast Questions

[erivkin54]

Jim, Thanks for the response. zeros force the numeric in the particular position. I am using zeros in my first format mask; the six position scenario for that reason. 9's permit numeric which is why I am using them in the 2nd scenario. It is the nine digit zip code. In many cases we only have the first five positions. When we have all nine, I want to allow numeric only in the remaining four positions after the '-'. If worse comes to worse I may have to break the column into two; forcing the first with numerics and allowing the 2nd column if the data is available. I was hoping to solve this with a format mask. Ed Apr 17, 2009 06:29:29 AM, rbase-l@rbase.com wrote: Ed, Try using zeros instead of the nines.  In the help section under “Format mask” I do not see the use of nines at all.  Jim From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of erivki...@verizon.net Sent: Thursday, April 16, 2009 10:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Form Format Mast Questions Hi RBASE-L, I am trying to use a format mask for 2 data columns in a form. Both are Text columns. I am converting a 4.5 form to 7.6. The form has been converted to 7.6 at this point. The first is a 6 position text column. I want to force a numeric in Pos 1 and 2, "X" in 3, numeric in Pos 4 and 5 and an optional O or alpha character in position 6. The current mask works fine for the first 5 characters but doesn't allow entry of the 6th character. Mask is: 00X00|;1;_ The 2nd challenge is a 10 position text column. The first five positions should be numeric only, a "-" in position 6, and optionally numeric only in positions 7-10. Current mask 99999-9999;1;_   is not allowing all the data to be entered. Thanks in advance for any assistance. Take care, Ed