Sytze, As I read you, you want the user to input up to 40 INDIVIDUAL 4-character codes. I would tend to display an EditBox for the 200-char field (it may well wrap), and below it use a 4-byte TextBox, with a few buttons beside it for OK, Junk, AddAnother, and Done.
You then have a simple, controllable input of each code, with the user able to repeat this as many times as necessary. As each code is accepted you add it to the display in the EditBox, so user can see whether he's done or not. Using an input mask saves you code, but neither you nor the users will ever figure out exactly how it works and errors will abound. Dan Covill ---------------------------------------- > Date: Fri, 13 Feb 2015 14:17:44 +1300 > Subject: Text box formatting > From: [email protected] > To: [email protected] > > I have a 200 char field > When data is input, I want to force maximum 4 char input, but there may be > 40 such sets > > I have tried input mask space space space space dash, 40 times > I have tried =replicate(" -",40) (4 spaces and a dash) > Neither seems to work > > Can anyone help me? > > -- > Kind regards, > Sytze de Boer _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
