>>>>>>>I've developed a grid in which I have several numeric fields bound to an open database. So far every thing works fine. Let's say I have a field called 'Numbers'. What I like is to display the value of this field in my grid as follows: "Nr: XXX", where "XXX" is the value of the field 'Numbers'. How do I do that?
>>>>>>>
>>>>>>>Michel
>>>>>>
>>>>>>Just put "Nr: 999" in the input mask.
>>>>>
>>>>>Hi Sonny -
>>>>>I haven't had any luck with this approach in grids - I was trying this sort of thing last week with my Format M thread. Have you actually gotten this to work in a grid column textbox?
>>>>
>>>>Use the Value property to change yourself your Input mask.
>>>
>>>I didn't have any luck with Value (or Controlsource), either. How do you mean to change the Inputmask in Value?
>>
>>you format yourself the value of the textbox like.
>>
>>value= TABLE.recName
>>THIS.Value= 'NR: '+STR(value)
>
>Yes, that should work too for individual textboxes or entire grid columns. The inputmask works fine also. But I couldn't get any method to conditionally allow some textboxes to be formatted one way and others another way in a grid column -- it's "format all the same way only" evidently.

Maybe if you add an IF statement, but this one is really tricky!