General information
Category:
Forms & Form designer
Thanks guys, the dynamicinputmask worked for me. Just curious, what would the next iif line be to check if 2, and then 3, decimal places are used? I see how the INT function identifies no decimals but what function(s)can check the amount of digits to the right of decimal? Thanks
>Allen,
>
>You need the DynamicInputMask property of the column. For example, to set the input mask to show no decimal places for a whole number and 1 for other numbers, use this:
>
>mygrid.column1.DynamicInputMask='IIF(MyField=INT(MyField),"99999","99999.9")'
>
>You can nest IIF's to handle 2 or 3 decimal places. You could also create a function or class to deal with it and call that from the DynamicInputMask. The function would just return the appropriate mask.
>
>>Hi,
>>
>>Can anyone tell me how to set a format/inputmask for a textbox(in a grid) that has it's controlsource set as a cursor.
>>Here's what happens:
>>
>>If I set this.grid.txtBox.controlsource='mycursor.myfield' and set the field type to N(7,3), the displayed number will show as 99999.999.
>>The problem I have is I want the display to show 999999 if .000 are the trailing numbers. But it displays as 99999.000.
>>If I enter for example 10.5 I want 10.5 but I get 10.500. I need up to 3 decimal places for this value but I don't want them displayed if it's zeros.
>>
>>The format property T (removes leading and trailing blanks) is sortof the property I'm looking for but that doesn't work here.
>>Is there a way to have the inputmask and format properties adjust a control whose controlsource is a cursor's field? I can't seem to get it to work.
>>
>>Thanks for any help
>>Allen
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only