>>>>>>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.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.