Formatting numaric field in grid.

[newtofoxpro]

How to show num field like transform(-252,"@ZXC 99999999.99")

Best Regards.

 

[Olaf Doschke]

Set the Controlsource to (Transform(numfield,"@ZXC 99999999.99")), in the outer brackets.

Or you set the Text1.InputMask to 99999999.99 and Text1.Format to ZXC, that should also do.

Bye, Olaf.

 

[newtofoxpro]

Thank you Olaf. Very quick help.
Best Regards.

 

[Mike Lewis]

Or you set the Text1.InputMask to 99999999.99 and Text1.Format to ZXC, that should also do.

Actually, isn't it the column's InputMask or Format that you should set, rather than the textbbox's? At least, that's what I've always done.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

I think both works, but perhaps you're right, you also rather set the controlsource at the column instead of the columns controls.

Bye, Olaf.