While ComboBoxes are the preferred way to do it, you can still use the M format and a variable or property to set the .InputMask value.
You should be able to change the value of choices by just resetting the .InputMask to a constant, variable or property. from some method on your form: thisform.textbox.inputmask = "val1,val2,val3" cList = "One,Two" thisform.textbox.inputmask = cList etc. Fred On Thu, Aug 4, 2011 at 9:02 AM, Jerry Foote <[email protected]>wrote: > I am trying to use the "M" in format with a string in the inputmask to > restrict data entry in 1 particular field. > > > > If I have "LIQUOR,BEER,WINE" as a literal the selection is limited to one > of > the selections. > > > > I would like to use a variable to define the selections. > > > > Does anybody know how to format the string to use in inputmask. > > > > I'v tried (),& > > > > Can't get it working > > > > Thanks Jerry > > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksro8dRdLrE_0GdU+rZk9dNzCPtw_QU8=czcu_omwqe...@mail.gmail.com ** 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.
