Hi,
I am sure there is a better way to do it, but I was able to make it work by entering inputmask in the property sheet
"99-99-99"
, then in the programmaticChange of the textbox I entered
This.Value=IIF(authorised,This.Value,"****"+RIGHT(This.Value,2))
and in the InteractiveChage
This.ProgrammaticChange()
Yelena
>Hi,
>
>I am using a textbox to display/edit a 6-digit number (bank-account sort-code, UK format) in different formats depending on whether the user is authorised to view/edit the full code or not.
>
>To this end I have a format code 'R' and an input mask set in textbox.refresh as follows...
> this.inputmask = IIF(authorised,'99-99-99','**-**-99')
>
>The first mask displays the code correctly as 12-34-56, but the unauthorised mask is displaying as **-**-12.
>
>How can I get the textbox to display digits in the right position, eg. **-**-56?
>
>TIA
>Alan