>>>What is the proper way to define a textbox if the data field is C(12,2) and the display should include the comma separaters? I would think an inputmask of ###,###,###.## would do it but this displays the commas even when the data is empty. Can't we display the commas only when there is data?
>>
>>I assume you meant N(12,2).
>>
>>Add a Z into the .function property of the textbox ("blank when zero")
>
>Yes I meant N(12,2). Oops.
>What do you mean by "function" property?
>Format = Z
OK now you guessed what I meant :). Yep it's the format property - that stuff used to be format picture functions (anything that went between an @ and a space in a picture clause or a transform()'s second parameter).
>InputMask = ###,###,###.##
>still displays the commas when empty.
Bind the textbox to a numeric field, or set its value to a number. If you try to display a(n empty) string using this input mask, you'll get the commas and the dot.