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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] 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
