From the online help:

The following demonstrates a typical format for cInputMask:

Column1.DynamicInputMask = "@R$ ###,###,###.##"
For additional information about the format of cFunction and cMask, see the Format and InputMask properties.

Now why anyone would want to hardcode something that's supposed to be dynamic is beyond me, but I guess, as Ed Rauh, may the Lord bless his soul, once replied to one of my frequent questions: It may be one of those cases where I'm totally clueless.

The reason I'm asking, is because I have a customer who, depending on the data, would like the individual fields in a row (not column) formatted according to the number of decimals in the nDecimals field in the underlying table.

So something like this came to mind:

.Column1.DynamicInputMask = ;
'#####'+ IIF(cTable.cField > 0,'.'+ REPLICATE('#',cTable.cField),'')

As far as I can see, that does nothing.

Any ideas on how to achieve this?


TIA

Peter